April 2017
Intermediate to advanced
436 pages
12h 7m
English
© Stelios Charalambides 2017
Stelios Charalambides, Oracle SQL Tuning with Oracle SQLTXPLAIN, 10.1007/978-1-4842-2436-6_4
Stelios Charalambides1
(1)New Hampton, New Hampshire, USA
In this chapter we’ll discuss what is considered a very important subject if you are tuning SQL. Collecting good statistics! 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 it and move on to the next problem. In Oracle 12c there is even more automated ...
Read now
Unlock full access