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/
New JOIN TO ONE clause in 26.2 SELECT
-
I've just published a short video on the new JOIN TO ONE clause in SELECT
statements in Oracle 26ai 26.2
This clause allows you to let the database auto...
Acum o săptămână
Niciun comentariu:
Trimiteți un comentariu