execution sequence of multiple conditions in WHERE clause
KaziJul 27 2011 — edited Jul 27 2011Hi Experts!!
if I have multiple conditions with AND in a where clause , what is sequence of execution of those conditions?
Like : SELECT *
FROM hr_employee
WHERE emp_no like '%E'
AND dept_no = 10
AND desig like 'MAN%'
AND sal > 5000
AND mgr = '%M'
AND role = 'SUPER';
In above conditions, which one will execute first? By altering the position of conditions in WHERE clause, can one increase performance of data retrieval?
Thanks &Regards
Mokarem