Archives of the TeradataForum

Message Posted: Fri, 13 Aug 2010 @ 12:59:46 GMT

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

Experts,

I have a table T1 which has the primary index as combination of columns C1 and C2. When I select using the condition on either C1 or C2, it is not using the index for fetching.

But when I use both columns for condition, it uses the PI.

Why is this happening?

Thanks,

Prasad

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