-
Hi friends,
Where is the information about the hashed values in a composite partitioning stored? Say, if a table is partitioned on range(date) and subpartitioned on a phone number. I can get the distinct phone numbers contained in a particular subpartition making a select distinct phone_num on the particular subpartition. But is there a better way to know all the phone numbers grouped by every subpartition? This information is requireed so that the queries can be designed accordingly.
Thanks
manjunath
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
|