If i apply a static data in where clause is it faster then applying a sub-query. Example:
(The query returns 5 records as a result set)
SELECT STARTDATE, ENDDATE FROM TEST WHERE STARTDATE = '2012-08-21';
is faster then :
SELECT STARTDATE, ENDDATE FROM TEST WHERE STARTDATE = (SELECT STARTDATE FROM TEST2 LIMIT 1);
or they are same in any case?
Sub-query executes each time a comparison perform by query with each record or only for 1 time?
WHERE STARTDATE = (SELECT STARTDATE FROM TEST2 LIMIT 1)
– ypercubeᵀᴹ Aug 25 '12 at 12:58TEST
table, say 1M rows. – ypercubeᵀᴹ Aug 25 '12 at 13:02