Hi,

You have to analyze the table in regular intervals, so that the CBO will
have latest statistics. The interval between collecting statistics you can
decide based on how fast the table is growing



----- Original Message -----
From: "Deepak Panda" <[Email Address Removed] "LazyDBA.com Discussion" <[Email Address Removed] Friday, February 27, 2004 6:33 PM
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
Oracle LazyDBA home page