|
-
I am unclear in the reason you want to partition the artificial PK. If it is for administrative reasons then it might be worthwhile. However, I don't think you will be gaining any performance.
Being the PK, most of your index hits (if not all) will not be range scans, therefore partitioning will be of little benefit. As others have mentioned, If you are looking to distribute your I/O, there are easier ways to do it.
Jeff Hunter
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
|