Rob van Wijkless info
|location||Utrecht, The Netherlands|
|visits||member for||2 years, 8 months|
|seen||Sep 6 at 15:21|
|bio||website||rwijk.blogspot.com||visits||member for||2 years, 8 months|
|location||Utrecht, The Netherlands||seen||Sep 6 at 15:21|
Query optimization [Oracle]
+1 for the excellent advice. You are describing Wolfgang Breitling's Tuning by Cardinality Feedback method. A little nitpicking though: this method is not an "explain plan", which is what you get after an explain plan statement and a subsequent "select * from table(dbms_xplan.display)". With dbms_xplan.display_cursor, you are looking at the actual plan and actual row cardinalities.