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