CHAPTER 3
How Object Statistics Can Make Your Execution Plan Wrong
In this chapter we’ll discuss what is considered a very important subject if you are tuning SQL. Gathering object statistics is crucial; this is why Oracle has spent so much time and effort making the statistics collection process as easy and painless as possible. They know that under most circumstances, DBAs who are under pressure to get their work done as quickly as possible, in the tiny maintenance windows they are allowed, will opt for the easiest and simplest way forward. If there is a check box that says “click me, all your statistics worries will be over,” they’ll click ...
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.
