Hi,
How frequentlly should one analyse the tables and indexes of a database in which where all tables are cleared (all rows deleted ) and populated again.

The following steps are taken

- Indexes Dropped
-All records from all tables deleted.
-Indexes recreated.

Since the indexes are being recreated do they need to be analysed so that CBO takes the best path.

Please Help.

Thanks
Anurag