Chsnge in PPI of a table


Chsnge in PPI of a table


There is a requirement to add a PPI to an existing table.

I havedone  two tests :

1. sel partition , count(*) from tablename group by 1. This shows me almost even distribution of data.

2. sel * from tablename where col1>date value. I have applied PPI on the col1 nd its a date column. This shows me partition elimination.

I just want to confirm if these two tests are sufficinet or i need to test some other as well.