O'Reilly logo

Oracle SQL Tuning with Oracle SQLTXPLAIN by Stelios Charalambides

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 3

image

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required