|
-
Originally posted by pando
well you can either export index stats (use dbms_stats.EXPORT_INDEX_STATS) before rebuild then import back (dbms_stats.IMPORT_INDEX_STATS) which takes seconds of time or rebuild with estimate or compute statistics clause
alter index emp_pk rebuild compute statistics;
Thanks pando, this is exactly what i searched
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
|
Reply With Quote