Assuming Oracle8i or later, read about DBMS_STATS package and the 'GATHER
STALE' option.

-----Original Message-----
From: Deepak Panda [mailto:[Email Address Removed] Friday, February 27, 2004 8:04 AM
To: LazyDBA.com Discussion
Subject: Statistics for CBO


Hi Gurus,

Will it be benificial if I collect statistics for a table which grows at a
very faster rate?

I am asking this because if i do this then i may need to collect the
statistics quite frequently, so that the CBO can take the right decission
while executing any query on the table.

Can someone please throw some light on it?

Thanks & Regards

Deepak

The information transmitted is intended only for the person or entity to
which it is addressed and may contain confidential and/or privileged
material. If the reader of this message is not the intended recipient,
you are hereby notified that your access is unauthorized, and any review,
dissemination, distribution or copying of this message including any
attachments is strictly prohibited. If you are not the intended
recipient, please contact the sender and delete the material from any
computer.
Oracle LazyDBA home page