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 !!?
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
What is relationship? How many types of relationship are there?
What are the two parts of design view?
Is not null in sql?
What are the different parts of a package?
explain the difference between myisam static and myisam dynamic. : Sql dba
What is the sql query to display the current date?
What is where clause in sql?
Can sql function call stored procedure?
How do you write a complex sql query?
what is data control language? : Sql dba
Can we call procedure in select statement?
What are the parts of a sql statement?
Are stored procedures faster than dynamic sql?
What are the different types of constraints?
Do stored procedures prevent sql injection?