How to find the tables which have PPI(partitioned primary index) ?
We make use of DBC.indices view to find any details regrading index.
SEL * FROM dbc.indices
WHERE indextype = 'Q' ---- 'Q' means Partitioned Primary Index
AND databasename = 'DATABASENAME' ;
Infact , DBC.Indices can be used to find out various types of index associated with tables in a given database.