Archives of the TeradataForum

Message Posted: Fri, 13 Aug 2010 @ 13:29:56 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hello Prasad,

The idea is simple you have defined your PI on C1 and C2 when you are using C1 or C2 in condition the optimizer cannot see the PI because PI is based on two columns not only one. Optimizer thinks that PI is C1+C2 for example studentLastname+StudentID. For optimizer C1 or C2 is simply a column not studentLastname+PI

But if you don't want to change your PI (from C1+C2) you can define a Secondary index on that column which you are using in condition so that response time will be better.

Thanks & Regards

Omer Shahzad

	<Prev	Next>		<<First	<Prev	Next>	Last>>