March 2023
Intermediate to advanced
270 pages
5h 51m
English
book
SQL Query Design Patterns and Best Practices
by Steven Hughes, Dennis Neer, Ram Babu Singh, Shabbir Mala, Leslie Andrews, Chi Zhang
Content preview from SQL Query Design Patterns and Best Practices
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
10
Understanding the Impact of Indexes on Query Design
In the previous chapter, we discussed the query optimization techniques—query execution plan. We discussed the Query Optimization Techniques, Query Optimizer, various query execution plans such as Estimated Execution Plan, Actual Execution Plan and Live Query Statistics. We discussed how to display execution plans, how to save execution plan in XML format, how to compare two execution plans and analyze an execution plan and how to use the execution plan to diagnose performance issue and fix them. With this, we added another tool to our toolkit of query optimization techniques to improve the performance of our queries to gain optimal performance.
In this chapter, we will learn about another ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access