CHAPTER 9
SQL Tuning Advisor
The last couple of chapters in this book deal with Oracle tools that generate recommendations to improve performance, namely
- SQL Tuning Advisor
- SQL Access Advisor
Both of these utilities generate advice regarding the implementation of indexes. Therefore, it's appropriate to discuss these tools in a book that focuses on indexing strategies. The emphasis of this chapter is the SQL Tuning Advisor, while Chapter 10 discusses the SQL Access Advisor. We'll briefly introduce the SQL Access Advisor here so that you can compare its features with the SQL Tuning Advisor and gain a better understanding of which tool to use ...
Get Expert Indexing in Oracle Database 11g: Maximum Performance for Your Database now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
