Interested to Buy Any Domain ? << Click Here >> for more details...
Which is best Subquery (or) joins in sql server? explain why
- 2 Answers
- 11211 Views
- I also Faced
- E-Mail Answers
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 |
Why are sql functions used?
If a table does not have a unique index, can a cursor be opened on it?
What are the steps you will take to improve the performance of a poor performing query?
between cast and convert which function would you prefer and why?
What is BCP? When does it used in sql server 2012?
0 Answers TryTechnicals Pvt Ltd,
What are the disadvantages of primary key and foreign key in SQL?
What is instead of trigger sql server?
Can you tell me the difference between DELETE & TRUNCATE commands?
Why do we need different type of parameter?
what is mean by constraints in sql?
What is the difference between commit and rollback?
How to skip remaining statements in a loop block using continue statements?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
