Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement