Are subqueries faster than joins?



Are subqueries faster than joins?..

Answer / Dharmraj Yadav

It depends on the specific query and data distribution. In some cases, a subquery may be faster while in others, a join might perform better.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

how to rename an existing table in mysql? : Sql dba

1 Answers  


IF i write before / after insert / update trigger and i do rollback what will happen?

5 Answers   KPIT,


how would you write a query to select all teams that won either 2, 4, 6 or 8 games? : Sql dba

1 Answers  


How to recompile a already made trigger?

2 Answers  


Is t sql a programming language?

1 Answers  


How to place comments in pl/sql?

1 Answers  


How can we avoid duplicating records in a query?

1 Answers  


explain the delete statements in sql

1 Answers  


What are the default Oracle triggers??

3 Answers   CGI, Tech Mahindra,


What is mutating error in pl sql?

1 Answers  


Define tables and fields in a database

1 Answers  


What are pl/sql exceptions? Tell me any three.

1 Answers  


Categories