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