-
Analyze Index (validate Structure)
Hello,
I have a table, which has more than 20 million records. When I am trying to validate the structure related to this large table, the process is taking really long time.
ANALYZE INDEX "INDEX_NAME" VALIDATE STRUCTURE;
Is there an option to use parallel processing to improve the processing speed? If not please let me know other options.
Thanks,
Nikee
-
Upgrade to Oracle9i then at least it won't lock out DML
Cheers
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
|