WL Information

Ideas for Better Returns

Finance Law

How to know which JOIN takes more time in case of multiple Joins?

Consider the following query:

SELECT *  
FROM Table1
INNER JOIN Table2 ON Condition1
INNER JOIN Table3 ON Condition2
INNER JOIN Table4 ON Condition3
INNER JOIN Table5 ON Condition4;

Is there a way to know which join takes more time when executing this query?