Reputation
Next privilege 125 Rep.
Vote down
Badges
1
Newest
 Supporter
Impact
0 people reached

  • 0 posts edited
  • 0 helpful flags
  • 2 votes cast
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.