Does Query Speed Depend on Order of WHERE Clause

samedi 4 avril 2015

Just writing some queries for 500K + records with a various restrictions in the WHERE clause and was wondering if the order in which I restricted the data would have any affect on query performance. Is it better to place the broadest restriction first and then filter down form there or does it not make any significant difference?

Does Query Speed Depend on Order of WHERE Clause

0 commentaires:

Enregistrer un commentaire

Labels