>>Hi everyone,
>>
>>I have two tables TranMstr and Lender. TranMstr table has Lender field (C 6) and Lender table has Code field (C 6)
>>TranMstr has an index on Lender and Lender table has index on code.
>>
>>I run the following SQL:
>>select * from TranMstr inner join Lender on TranMstr.Lender=Lender.code where etc.
>>
>>sys(3054,11) shows, that in joining expression SQL uses temp index. Why?
>>
>>Thanks in advance.
>
>Ok, disregard my question. I was sure, TranMstr has Lender index, but I just checked, it it doesn't! So we will add this index to TranMstr table.

Ok, I added Lender tag in TranMstr, but it still is not used in optimization. It still shows 'using temp index'...
Does it mean, that both tags should have the same name 'Lender' in order to be used in Join optimization?

I'm realy confused. Could somebody shed a light on this problem, please?

Thanks in advance.