RE: Incorrect cardinality estimate

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Thu, 01 Feb 2007 09:09:58 -0700
Message-Id: <20070201160920.677FD5CE417@turing.freelists.org>

I should perhaps clarify that with "gather any column statistics separately" I mean to seperately gather column statistics for the (few) columns where I have identified that a histogram is beneficial. And then of course it is simply a matter of issuing a series of gather_table_stats(ownname, tabname, estimate_percent=>100, method_opt=>'for columns size {254 | skewonly} colname');

At 08:53 AM 2/1/2007, Joseph Amalraj wrote:
>That's very good advice for gathering statistics.
>
>Please let me know how do you
>
>gather any column statistics separately with estimate_percent=>100

Regards

Wolfgang Breitling
Centrex Consulting Corporation
www.centrexcc.com

---

This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email

---

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Feb 01 2007 - 10:09:58 CST