Thanks a lot Charles and Jonathan. (I did not have jonathan's book
handy to refer).
Sorry for missing out some important parts.
I'am using Oracle 9.2.0.4 on Sun Solaris 8. The stats are gathered
every week. I generated the plan using Explain plan and
DBMS_XPLAN.DISPLAY. The actual execution plan is also the same as i
verified the STAT records in the 10046 trace. I'am planning to use
histograms on ITEM_TYPE_CODE. (only 2 distinct values but only .38%
have a value of 'MDL')
This will cause it to drive from ASO_QUOTE_LINES_ALL.
Thanks & regards
srivenu
Received on Thu Sep 28 2006 - 12:35:02 CDT
