|
-
Analyzing index will infact improve the performance and I do analyze of some of the schemas in my database every day .
My options are :
estimate , 15%
I use DBMS_UTILITY.ANALYZE_SCHEME
rebuilding indexes is not a daily activity , but analyzing should be a daily one in order to provide a right feed to CBO to improve performance.
Thanks,
Madhu
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
|