Analysing Tables and Indexes

From: Anurag Minocha <aminocha_at_herold.com>
Date: Thu, 15 Mar 2001 18:26:01 +0000 (UTC)
Message-ID: <EBBA6D3A81229C42981E3AEA79BF5A4E11123D@jshemail.herold.com>

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

--

Posted from sjc3-1.relay.mail.uu.net [199.171.54.122] via Mailgate.ORG Server - http://www.Mailgate.ORG Received on Thu Mar 15 2001 - 12:26:01 CST