-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|