Re: Creating Histograms

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 21 Jul 2004 22:25:44 +0100

Note in-line.


Jonathan Lewis
The Co-operative Oracle Users' FAQ
Optimising Oracle Seminar - schedule updated July 20th

----- Original Message ----- 
From: "Wolfgang Breitling" <breitliw@xxxxxxxxxxxxx>

>> 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:
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
Archives are at
FAQ is at

Other related posts: