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 live online training, plus books, videos, and digital content from nearly 200 publishers.