What is the first action to perform a query?
Suppose I have four tables and five joins and my query is
getting slow day by day.
Answer Posted / vaibhavi_dixit
Also check that the tables does not have more NULL values,
which also reduces the performance.
VD
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Does inner join return duplicate rows?
Explain mutating table error.
Under what condition it is possible to have a page level lock and row lock at the same time for a query? : Transact sql
Define concurrency control. : Transact sql
What are functions in sql?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Does asenumerable execute the query?
What is tuple in sql?
How delete all records from table in sql?
Is like operator in sql case sensitive?
Why is %isopen always false for an implicit cursor?
What is the difference between cross join and natural join?
What is sqlcontext?
What does select count (*) mean in sql?
What is the difference between rename and alias?