Interested to Buy Any Domain ? << Click Here >> for more details...
Can any one tell me how to increase the performance of a
sql query ie what are the performance tips in creating or
writing a sql query !!?
- 3 Answers
- 12389 Views
- eBay, I also Faced
- E-Mail Answers
Answer Posted / manoj
1.
Use proper sequence of tables in from clause
i.e.
the table have more common column must in last
in form clause bcoz on firing of query engine link
last table in form clause
2.
Use "Exist" clause instead of "Not in"
Bcoz it return only true/false(boolean)
3.
Use "Hint" if Required
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
define sql delete statement ? : Sql dba
how do you tune the slow running queries in oracle db , explain the methodology
What is cross join sql?
What is identity column in sql server?
How does sql store data?
How does a covering index work?
Explain sql data types?
How do sql databases work?
Are views faster than queries?
What does (+) mean in sql joins?
Is t sql a programming language?
What is sequence in sql?
mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql
what is the difference between delete and truncate commands? : Sql dba
What do you mean by “trigger” in sql?
