|
-
I afraid, that is not the right solution. PCT_FREE is taken only during the index rebuild, while your issue is right hand "hot blocks" during the normal operation - insert. You should use either Hash Partitioned Index or Reverse Key index. I will not suggest Reverse key index as Range Scan is not supported, so I will go for Hash partitioned Index.
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
|