|
-
a) Size of truncated partition - Table has 1 column with 2 partitions - One partition has 12 million rows and second has 8 million rows.
b) Quantity of Global Indexes - 13.
Clearly, the size of truncated partition is high enough for performance draining. Is there a way I can optimize this by increasing the number of partitions? Any alternative method?
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