RE: Creating Histograms

In the antique 13 had always been a good luck number, because christ died 
this tried to become a bad luck numbre,
 but for me is still a good luck number;
-------Original Message-------
 
From: oracle-l@xxxxxxxxxxxxx
Date: 07/22/04 19:26:19
To: 'oracle-l@xxxxxxxxxxxxx'
Subject: RE: Creating Histograms
 
13 isn't some kind of unlucky number for Oracle, is it?
 
One of the application teams added a "code" table (I'm pretty sure it was
indexed, but definitely analyzed) that only had 13 rows and it killed the
application.
 
Code re-write solved the issue. After it was in production, of course.
 
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Jonathan Lewis
Sent: Thursday, July 22, 2004 6:19 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Creating Histograms
 
 
 
It's an quirky little paradox that big tables
are usually fine with a small sample, but
small tables need the best possible stats.
 
An error of 'a couple of rows' in a small
table is, after all, likely to be a significant
percentage error.
 
 
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: "Niall Litchfield" <niall.litchfield@xxxxxxxxx>
 
 
take note of how many records you add to relatively *small* tables. 13
rows added to one of our tables caused hell until we gathered stats
again (and it took ages for anyone to admit that anything ahd
changed). That would be 13 rows in the sense of another financial year
to add to the 2 existing ones - so hardly significant at all :).
 
 
 
----------------------------------------------------------------
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
 
 
**********************************************************************
The information contained in this communication is
confidential, is intended only for the use of the recipient
named above, and may be legally privileged.
If the reader of this message is not the intended
recipient, you are hereby notified that any dissemination,
distribution, or copying of this communication is strictly
prohibited.
If you have received this communication in error,
please re-send this communication to the sender and
delete the original message or any copy of it from your
computer system. Thank You.
 
----------------------------------------------------------------
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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: