Which is best Subquery (or) joins in sql server? explain why
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / parmanand
Joins are good, Sub queries are substantially faster than
cursor in most cases, however shower than other options that
might be available in SQL Server.
Is This Answer Correct ? | 5 Yes | 5 No |
Where are sql server user names and passwords stored in sql server?
How to update existing rows in a table?
What is an index?
How to find the version of sql server? : sql server database administration
Explain external key management in sql server 2008
Tell me what are the advantages of using stored procedures?
What is simple indexing method?
What is SQL Profiler what is the use of it?
2 Answers 247Customer, Steria,
What is the full form of dql?
How many types of cursor type are there?
What factors you will consider calculating the storage requirement for that view?
How do I create a stored procedure in dbml?