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
- 12498 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 subquery? : Sql dba
is mysql query is case sensitive? : Sql dba
Why use subqueries instead of joins?
How do you truncate?
How do you delete a table?
What is package in pl sql with an examples?
Explain ttitle and btitle.
discuss about myisam key cache. : Sql dba
what is a materialized view? : Sql dba
What is the starting oracle error number?
how to create a test table in your mysql server? : Sql dba
Is hadoop a nosql?
What are the topics in pl sql?
What happens when a trigger is associated to a view?
how can you see all indexes defined for a table? : Sql dba
