|
-
Originally posted by tamilselvan
===================================
Our queries are going to be over the field FIELD1_PK on the where clause and that number is generated using a sequence.
===================================
Seq Number is not a good candidate for partition key, because seq number does not have any attribute value. It is just used to enforce PK.
If it's used as a predicate, then there's nothing wrong with using it as the partitioning key. Assuming that there is some benefit to partitioning in this case.
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
|