Abstract
This chapter presents examples of the different ways that query execution plans are presented both in text and graphically by the major database vendors and illustrates how they can help improve physical database design. The ability to view query execution plans and some of the associated resource and selectivity for operators within the plan is a major tool in the process of physical database design. No modern database is effectively designed without exploring access paths. The access path analysis help the database designer see where the resource hot spots are and whether the designs attributed that they have created in the database are being exploited. When the database design seems good, but the query optimizer is not selecting the available design feature, some adjustments may be needed by the administrator to set things right. The possibilities include adjusting the optimization search depth, modifying the statistics for objects used in the offending query, or adding query hints to force the query execution plan choices for specific queries.
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.
