Why do we use joins, instead subquery has same operation?

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.

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.

Answer Question  Select Best Answer

robindas

 Profile Answers by robindas Questions by robindas

• Jan 11th, 2013

Few steps for query tuning. 1) Check for if any sub query or exists or not exists is there if yes then try to change it in the joins 2) Try to check the way joins had been written try to put it in f...

samareshoracle

 Profile Answers by samareshoracle Questions by samareshoracle

• Aug 4th, 2012

Following a Tuning Methodology Objectives:: • Determine performance problems • Manage performance • Describe tuning methodologies • Identify goals for tuning • Describe automatic SQL tunin...

Answer Question  Select Best Answer