Koonal saxena

 Profile Answers by Koonal saxena Questions by Koonal saxena

• Dec 20th, 2012

 

Joins are performance killer

robindas

 Profile Answers by robindas Questions by robindas

• Jan 11th, 2013

 

The subquery scan the complete table to apply so its slow whether joins are much faster.

Shanu

• May 17th, 2015

 

subquery can be used for simple logical queries , to get
required output/condition
but if you want to compare two or more tables and get output
in the way you want it would be lot difficult to manage all
those with subqueries - so we can use the concept of joins

kushal lohakare

• Aug 5th, 2015

 

JOIN - Join is a query, which retrieves columns or rows of multiple table.
SUBQUERY - Subquery is a query, whose return values are used in filtering condition of main query.

farhan

• Oct 15th, 2015

 

JOINs are used where you have a complex and large queries. SubQuery is used where you have a very simple scenario and your query is not too lengthy.

laxminarayana

• Oct 16th, 2015

 

JOINS are used to retriveing data from more then one table.
SUBQUERIES are used to condition depends upon one data retriving from another table at the time we use subqueries.