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 -----------------------------------------------------------------