All Forums General
Purushotham 87 posts Joined 04/14
20 Jun 2014
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?

Could anyone please explain me.

Thanks in advance.

Regards,
Purushotham.

Purushotham.M
Raja_KT 1246 posts Joined 07/09
21 Jun 2014

You have not shared your DDL, so that it will be specific.
You can see it using explain. The best one to explain is the Optimzer :)
You can have a look at this post. It may be of your interest.It talks about SI though.
http://forums.teradata.com/forum/tools/when-are-secondary-indexes-required
 

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.