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
- 11513 Views
- eBay, I also Faced
- E-Mail Answers
Answer Posted / hutashan
use Inline view to eleminate large number of rows
Avoid implicit datatype conversion
Avoid using function on an indexed column
Avoid comparing column value with NULL
Outer Join
Use OR carefully
Do not use outer join unless absolutely necessary. Degree
of optimizing outer join permutation is VERY LIMITED
Instead: Consider using default values in the base table to
avoid outer join
Do not outer join to a view. This typically results in a
non-mergable view execution plan
Always use NOT EXISTS instead of NOT IN
Remove DISTINCT keyword from SELECT if UNION is used
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain exception handling in pl/sql?
What is trigger types of trigger?
Is sql pronounced sequel or sql?
What does bitemporal mean?
what is sql? : Sql dba
Explain correlated query work?
What is foreign key sql?
How do you rename a table in sql?
What is the use of <> sql?
What are the advantages of stored procedure?
Why do we use view in sql?
Is pl sql different from sql?
What is normalization in sql?
how to shutdown mysql server? : Sql dba
What is sql trigger example?
