How does SQL (eg MySQL) construct multiple conditions?
If we have complex query, can sorting the where clauses speed up the process?
Does it have any performance difference if we sort the clauses from the
possibly smaller returns to larger?
Eg:
from 1.000 of people.
700 are female,
which 300 of them are graduated
which 50 of them are also musicians.
1
WHERE gender = 'female'
AND education = 'college'
AND hobby = 'music'
Or better to be this?
2
WHERE hobby = 'music'
AND education = 'college'
AND gender = 'female'
No comments:
Post a Comment