-
ALTER INDEX REBUILD drops statistics ...
Oracle 8.1.7.3.50 EE/MVS
Hi,
After Rebuilding the Indexes
the LAST_ANALYZED-Attribute is set to NULL,
The Statistics for the index is gone.
Problem is that the CBO goes grazy with indexes when
no statistics is available ( FULL-TABLE-SCANS ).
Is there a trick to rebuild the index without dropping the old statistics ( till a new gather of stats ) ?
Orca
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
|