Interested to Buy Any Domain ? << Click Here >> for more details...
How do you optimize SQL queries ?
- 6 Answers
- 36105 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
Which certification is best for sql?
How can we store rows in PL/SQL using array?
How do I partition a table in sql?
What are keys in sql?
Can cursors be part of a trigger body?
How do rank () and dense_rank () differ?
How does sql*loader handles newline characters in a record? : aql loader
How do I remove sql developer from windows 10?
What is the difference between explicit and implicit cursors in oracle?
What is the difference between microsoft access and sql server?
What is the difference between cluster and non-cluster index?
What is an invalid partition table?
what is a cursor? : Sql dba
What are commit, rollback, and savepoint?
What is the use of partition by in sql?
