Interested to Buy Any Domain ? << Click Here >> for more details...
How do you optimize SQL queries ?
- 6 Answers
- 35801 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
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
how many columns can be used for creating index? : Sql dba
How does index help in query performance?
Why should I use postgresql?
What program will open a mdb file?
Does postgresql run on the cloud?
What is a table?
Does mysql support pl sql?
what is online transaction processing (oltp)? : Sql dba
How do I install sql?
What is query optimization in sql?
Is it possible to link two groups inside a cross products after the cross products group has been created?
What is the syntax and use of the coalesce function?
Can we rollback after truncate?
Is there a 64 bit version of ssms?
