101 reputation
1
bio website rwijk.blogspot.com
location Utrecht, The Netherlands
age
visits member for 3 years, 6 months
seen Sep 17 at 7:31

Jun
5
comment 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.
Mar
30
awarded  Supporter