Breaking News: Grepper is joining You.com. Read the official announcement!

What is performance wise better join or a subquery ?

Enchanting Eagle answered on June 25, 2022 Popularity 8/10 Helpfulness 2/10

answer What is performance wise better join or a subquery ?

What is performance wise better join or a subquery ?

Comment

The advantage of a join includes that it executes faster.
The retrieval time of the query using joins almost always will be faster than 
that of a subquery. By using joins, you can maximize the calculation burden on
the database i.e., instead of multiple queries using one join query

Popularity 8/10 Helpfulness 2/10 Language sql

Source: www.GeeksforGeeks.com

Tags: join performance sql subquery wise

Link to this answer
Share Copy Link