Again another analyze question...

For example let say I have 5 tables with the # of records listed below:

table_a = 1487
table_b = 73871
table_c = 67015
table_d = 492
table_e = 67015

Should I compute each table or should I calculate each table and estimate
the statistics where
the number of rows any where between 10-15%. Which method is efficient?

>>>>Note:The number of records in these tables are not going to change
dramatically.

Thanks.....

Oracle LazyDBA home page