mardi 3 février 2015

Are indexes used when joining tables?


I know that joins of type Sort-Join don't use indexes, because they work by sorting both tables and then joining them.


But I've read recommendations to index all FKs, I believe that's for helping joining.


Is there then some type of join that uses nonclustered indexes?





Aucun commentaire:

Enregistrer un commentaire