-
I have a table which is partitioned by month. We keep last few months of records and delete others (drop partition...)
We are using sqlldr to load the data into table.
Intially this table had global index due to the perf. problem we changed it to local index.
Now during the load I want to disable or drop the local index for one of the partition which is going to use during the load so it can improve the perf during the load.
Any suggestion?
Thanks
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
|