complexity of following join sql query [duplicate]
January 23, 2022Which clause performs first in a SELECT
statement?
I have a doubt in select
query on this basis.
consider the below example
SELECT *
FROM #temp A
INNER JOIN #temp B ON A.id = B.id
INNER JOIN #temp C ON B.id = C.id
WHERE A.Name = 'Acb' AND B.Name = C.Name
- Whether, First it checks
WHERE
clause and then performsINNER JOIN
- First
JOIN
and then checks condition?
If it first performs JOIN
and then WHERE
condition; how can it perform more where conditions for different JOIN
s?