CHAPTER 15
The Final Word
The key to successful tuning with SQLT is to use SQLT regularly and for real-life problems. If you’ve reached the final chapter, you should now consider yourself a card-carrying member of the SQLT supporters club. You’ve learned a lot about what SQLT can do, and along the way you’ve probably learned some things about the cost-based optimizer and the Oracle engine. Let me remind you of some of the features we came across on our journey:
- The effect of statistics on execution plans
- The effect of skewness on execution plans
- How the optimizer transforms SQL during parsing
- How profiles can help you temporarily freeze an execution ...
Get Oracle SQL Tuning with Oracle SQLTXPLAIN 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.
