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

how to enter characters as hex numbers? : Sql dba

0 Answers  


Let us suppose we have a table with structure in order empno empname empdesig empcountry and now i want to re-organize the columns of this table to empno empdesig empname empcountry how can i do this with queries ? assume that table contains the data.

3 Answers  


Are stored procedures faster than queries?

0 Answers  


What is microsoft t sql?

0 Answers  


what is an alias command? : Sql dba

0 Answers  






what are the demerits of sql?

1 Answers  


What is the difference between SQL Constraint and PL/SQL constraint.Pls give all the constraint name.

3 Answers   TCS,


How can a function retun more than one value in oracle with proper example?

0 Answers  


Why do we create stored procedures & functions in pl/sql and how are they different?

0 Answers  


What are system versioned tables?

0 Answers  


what are date and time intervals? : Sql dba

0 Answers  


What is the difference between microsoft access and sql?

0 Answers  


Categories