2012-07-30

how to collect statistics in exadata

In case you have an oracle exadata database machine, always use 100% percent for collecting optimizer statistics on your tables/schemas , in order to benefit from the smart scans .

http://uhesse.com/2012/07/04/no-smart-scan-with-auto_sample_size/

Niciun comentariu:

Trimiteți un comentariu