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

Can procedure in package be overloaded?

0 Answers   EXL,


What is primary key and foreign key?

0 Answers  


how to find the First and Last Observation from the table: Ex: OBS Name Sal Ans like: OBS Name Sal 105 E 5000--> 105 E 5000 102 B 2000 104 D 4000 103 C 3000 101 A 1000--> 104 D 4000

4 Answers  


What are the different types of constraints?

0 Answers  


one of the column in my table contains the data like SAL ---- 1000 1000 2000 3000 3000 So my requirement is i want output like SAL --- 1000 2000 3000 it mean i want to delete duplicate rows in the table permanently and i want output in the above formatow should u write query?

13 Answers   Cap Gemini, TCS,






What are different types of refreshment techniques of materialised view

2 Answers  


What are the benefits of triggers?

0 Answers  


what is oracle sql,pl/sql with interfaces

2 Answers   TCS,


How to execute OS(operating system) command from pl/sql?

3 Answers  


how to enter binary numbers in sql statements? : Sql dba

0 Answers  


Can a varchar be a primary key?

0 Answers  


what are the tunnig tables you used for tuning a query and tell me some of coloumns in that tuning tables?

1 Answers   Metric Stream,


Categories