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
- 12383 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
What is minus?
What is pl sql quora?
What is pl sql and why it is used for?
What is consistency?
which command using query analyzer will give you the version of sql server and operating system? : Sql dba
What is %type in sql?
how can we know the number of days between two given dates using mysql? : Sql dba
When you have to use a default "rollback to" savepoint of plvlog?
What is the mutating table and constraining table?
what are the differences between require and include, include_once and require_once? : Sql dba
Why is a primary key important?
What is record type in pl sql?
Why do we use partitions in sql?
Does view store data in sql?
Does truncate remove indexes?
