From what you said, your indexes are correct. Are you sure the join expression is exactly the same as the one in the index? I tried it using the Tastrade sample database and it doesn't report any temp index.

As for the "none"s reported by sys(3054,1), this is normal since there's no whre condition on either table.

Vlad

>What bothers me is that the SYS(3054,11) and the SYS(3054,1) function always displays:
>
>Rushmore optimization level for table a: none
>Rushmore optimization level for table a: none
>or
>Joining table a and table b using temp index
>
>I double checked my database and i have all my indexes in the tables.