Abstract
This chapter provides examples from the automated design utilities for DB2, structured query language (SQL) Server, and Oracle. It presents an overview of the features as well as a review of strategies and research used. Utilities for automated physical database design are based on advanced technology with considerable sophistication. For database systems, automated physical database design always plays a prominent role due to the massive impact that it can play on system performance and ease of administration. Much of the literature on automated physical design has focused on the possibility of “what-if analysis” using the database's existing query optimizer. “What-if analysis” is the art of carefully lying to the query optimizer and observing the impact. To discover where additional indexing will be beneficial the definition of a new index is added to the physical design of the table within the memory of the system strictly for exploration purposes.
Sign-in/Register to access full text options 
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
