Archives of the TeradataForum
Message Posted: Fri, 13 Aug 2010 @ 12:59:46 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|