Which is faster subquery or join?


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

Post New Answer

More SQL PLSQL Interview Questions

Can a trigger call a stored procedure?

0 Answers  


Is subquery faster than join?

0 Answers  


Can you selectively load only those records that you need? : aql loader

0 Answers  


What is difference between CHAR and VARCHAR2?What is the maximum SIZE allowed for each type?

6 Answers   Saama Tech,


What is the difference between inner join and left join?

0 Answers  






What is meant by cursor in sql?

0 Answers  


How many triggers can be applied on a table?

0 Answers  


what is the purpose of update command in oracle?

7 Answers   MBT,


How we can update the view?

0 Answers  


In what condition is it good to disable a trigger?

0 Answers  


table having two columns - entity,zone enity zone pen east pen west pen north pen south pen east pencil east pencil east pencil west I want the output as : entity east west north south pen 2 1 1 1 pencil 2 1 0 0

2 Answers  


How to avoid using cursors? What to use instead of cursor and in what cases to do so?

0 Answers  


Categories