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/
Everything Changes
-
I saw a recent tweet (on Bluesky) from SQLDaily highlighting a blog note
that Lukas Eder wrote in 2016 with the title: “Avoid using COUNT() in SQL
when you...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu