>>>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?
Erik Moore
Clientelligence