Interested to Buy Any Domain ? << Click Here >> for more details...
Which is best Subquery (or) joins in sql server? explain why
- 2 Answers
- 11202 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajeevrohilla
In normal situation join are best since there is no
subquery for each record for the other table. but in some
situations Subquery are best. for example- when the
subquery results one or fewer (3 or 4 records) that it will
work faster since it also saves the joining time(if there
are more than 1 joining fields then joining takes lots of
time). Subquries also perform better when tables have less
amount of data.
| Is This Answer Correct ? | 17 Yes | 4 No |
Post New Answer View All Answers
what is create database syntax? : Sql server database administration
How to create prepared statements using odbc_prepare()?
What is model database in sql server?
What is sql server used for?
Can we hide the definition of a stored procedure from a use?
What are 3 ways to get a count of the number of records in a table?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas
What is the difference between substr and charindex in the sql server?
How to create user defined functions with parameters?
Does a full backup include transaction log?
What is subquery explain with example?
What is plan freezing?
How to sort the query output with order by clauses in ms sql server?
Explain the concept of recursive stored procedure.
