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
- 12195 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
Can we debug stored procedure?
What operating systems are supported by oracle sql developer?
Can we create table inside stored procedure?
What is the difference between union and union all command?
What is rank () in sql?
what are all the common sql function? : Sql dba
What is database white box testing and black box testing?
What are the possible values that can be stored in a boolean data field?
how many triggers are allowed in mysql table? : Sql dba
How do you write a subquery?
What is the advantage of nosql?
what is auto increment? : Sql dba
Why we use stored procedure instead of query?
Is sql scripting language?
What is a left join?
