Interested to Buy Any Domain ? << Click Here >> for more details...
How do you optimize SQL queries ?
- 6 Answers
- 35617 Views
- CarrizalSoft Technologies, Infosys, Oracle, I also Faced
- E-Mail Answers
Answer Posted / hutashan
Avoid implicit datatype conversion
Avoid using function on an indexed column
Avoid comparing column value with NULL
Outer Join
Use OR carefully
Always use NOT EXISTS instead of NOT IN
Use UNION ALL whenever possible (no implicit sorts)
UNION will sort the result set for each SELECT before
combining the final result set
Remove DISTINCT keyword from SELECT if UNION is used
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Explain constraints in sql?
What is the use of count (*) in sql?
How do you drop a trigger?
Can you join views in sql?
Explain the methods used to protect source code of pl/sql.
How many unique keys can a table have?
what is cursor and its type, what is ref cursor write a syntax to pass ref cursor into procedure out fucntion and call the procedure
What is an inconsistent dependency?
How many types of privileges are available in sql?
What is assignment operator in pl sql?
How many sql statements are used?
What are sql built in functions?
Is left join inner or outer?
What is procedure explain with example?
What is the reports view in oracle sql developer?
