Re: Creating Histograms

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Wed, 21 Jul 2004 22:25:44 +0100
Message-ID: <018001c46f69$47fb3070$7102a8c0@Primary>

Note in-line.

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Optimising Oracle Seminar - schedule updated July 20th

• Original Message ----- From: "Wolfgang Breitling" <breitliw_at_centrexcc.com>

>> Otherwise I practice "plan stability" meaning "if the statistics
>> don't change, the plans won't".

Beg to differ - for example:

The fixed predicate:

    last_update_date >= "calculated constant of 28 days ago" is likely to have a selectivity that changes as time passes, with a possible change in plan, precisely BECAUSE the statistics haven't changed.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Wed Jul 21 2004 - 16:22:18 CDT