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.
rights to materials on this website, the rights you grant to your submissions to this website, and your responsibilities regarding your conduct on this website.