General
Enthusiast

## I have defined PPI on a table,if i use PI in where clause,whether it go and search each and every partition or single partition

Hi Everyone,

I defined PPI on a table,but I am not using PPI column in where clause.
I am using PI in the where clause,whether it go and search each and every partition or single partition?

Regards,
Purushotham.