Skip to content
Advertisement

which gives best performance?

Please go through the following query, and help me to understand which one is efficient and how?

In logical query execution, where clause will be executed after completion of join, so I thought the query 2 will gain the performance benefits. Is that right?

Query 1:

Query 2:

Thanks in advance

Advertisement

Answer

User contributions licensed under: CC BY-SA
4 People found this is helpful
Advertisement