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
- 11224 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
What is the difference between delete and truncate commands?
How sql query is executed?
What is flag in sql?
How do you select unique values in sql?
Can we use views in stored procedure?
How many types of triggers exist in pl/sql?
How does left join work in sql?
what are the limitations of identity column? : Transact sql
What is hibernate and its relation to sql?
Is a foreign key always unique?
does sql support programming? : Sql dba
Does execute immediate commit?
How many types of cursors are available in pl/sql?
Can you sum a count in sql?
What are the benefits of pl/sql packages?
