HI TD Experts,
I have defined PPI on a Table.But i am not using PPI in the where clause, am using PI in the where clause.
Whether it performance decreases or not ?
If it decreases the performance, why it decreases? please tell me the reason.
Thanks in advance..
Hi.if you have where clause on the PI then its better not to have a PPI on the table, it will degrade th eperformance.Why.? because for getting the PI value it has to go through wach and every partitions.
So its always better not to have PPI if ur query is on PI.
It's not always better, only if the partitioning column is not part of the PI.
And the performance decrease mainly depends on the number of populated partitions, if it's just a few performance might still be ok.