Why join is faster than subquery?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

i declare 4 procedure in package specification but in package body i write only 3 procedure. is it complie??//w

4 Answers   Scope International,


how to insert values like 10:10:00,30:25:00 etc.into table after insert how can i sum the above insert values to get the result as 40:35:00

3 Answers  


Why do we use subquery?

0 Answers  


What are the attributes of SQL*PLUS ?

2 Answers   Dream Careers, Oracle,


what are the advantages of package?

7 Answers   iFlex,






What are different joins used in sql?

0 Answers  


How many joins can you have in sql?

0 Answers  


What is a behavioral trigger?

0 Answers  


What are sql functions? Describe the different types of sql functions?

0 Answers  


i need department wise top 2 employees salary.which logic i will use

17 Answers  


How to read/write files from pl/sql?

0 Answers  


what are the advantages of using stored procedures? : Sql dba

0 Answers  


Categories