Hi David, then how do you get cbo uses the histogram and do a full scan, when this is more than 90% of the data changing the optimizer index parameter? If you can't get CBO use the histogram by himself, you get nothing. -------Original Message------- From: oracle-l@xxxxxxxxxxxxx Date: 07/21/04 14:26:32 To: oracle-l@xxxxxxxxxxxxx Subject: RE: Creating Histograms Unless I'm mistaken I believe the concensus on here is that a higher cost does not necessarily indicate a poorer plan. Just wanted to point that out in reference to the cost being higher mentioned below...+ -- . David > But it seems not to be, a full scan cost 40 more, so it seems this is not > a > good place to use histograms.- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------