The question is on .Q.dpft and db layout.
1. Is the difference between #g and #p is that internally a hashtable is maintained of unique values to each index of the value in the column for #g while #p maps unique value to the first index of the value ?
2. Dont quite get the definition of .Q.dpft. If a virtual column (invisible column date) is actually partioning the table, then how is the column f in dpft again having attribute #p ? It wont work because a specific partition per col f might be split across two partitions.