>>>>Hi everybody,
>>>>
>>>>I'll try to rephrase my previous post, since I got 0 answers. Suppose, I have two tables, which I want to join:
>>>>Table1 with field code1 and index on code1 tag code1
>>>>Table2 with field code2 and index on code2 tag code2
>>>>
>>>>select * from Table1 inner join table2 on code1=code2 ...
>>>>It seems to me, that if tag names are different (code1 and code2), these indexes aren't used in optimization. Instead SQL creates temp index.
>>>>
>>>>Could somebody confirm this behavior? Why it's so?
>>>>
>>>
>>>Rushmore uses index expressions, not names, to decide what index to use.
>>
>>Ok, why it doesn't use code1 index and code2 index in this case? What's going on here?
>>
>
>How are you determining that the indexes are not being used?
sys(3054,11) shows, that temp index used in Join...
If it's not broken, fix it until it is.
My Blog