Interested to Buy Any Domain ? << Click Here >> for more details...
How do you optimize SQL queries ?
- 6 Answers
- 35624 Views
- CarrizalSoft Technologies, Infosys, Oracle, I also Faced
- E-Mail Answers
Answer Posted / abhijit
Use query analyzer to see the execution path and find
bottlenecks such as full table scans for tables with huge
number of rows.
Make sure you use the indexed columns in where clause, this
can lead to a phenomenal jump in query execution speed.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How are functions and procedures called in PL/SQL?
What is sql in java?
Explain dml and ddl?
How do you optimize a stored procedure in sql?
Why is sql better than hql?
what are all different types of collation sensitivity? : Sql dba
Is sqlexception checked or unchecked?
Why use triggers in sql?
what is the difference between a local and a global temporary table? : Sql dba
What does subquery mean in sql?
How many times can we commit in a loop?
What is difference between table and view?
What is pl sql and why it is used for?
What is a data manipulation language?
What is the difference between having clause and where clause?
