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/
xb.sql and xbi.sql - Explain Oracle Execution Plans Better! (Part 3 - 
Cardinality Misestimates)
                      -
                    
Here’s part 3 of my xb.sql & xbi.sql article series that I started writing 
back in 2019 :-) Part 1 - Show and format execution plans by querying 
V$SQL_PLAN...
Acum 22 de ore
Niciun comentariu:
Trimiteți un comentariu