How can you tune SQL statements?
Answers were Sorted based on User's Feedback
SQL Statements can be tuned depending on the Database,
different DBMS provides different types of the execution
plan, Oracle provides "Explain Plain" which explains the
cost of the query. Using which we can estimate the cost and
make the necessary changes like creating indexes........
| Is This Answer Correct ? | 0 Yes | 0 No |
What is thin driver in jdbc?
What are static and dynamic queries?
Discuss the procedure of retrieving warnings?
What is jdbc thin client?
What is the difference between setmaxrows(int) and setfetchsize(int)?
What is JDBC API and when do we use it?
Hi friends, In JDBC 4 drivers are there among this which driver is best and why it is best.Which driver is most commonly used in web applications.
How does jdbc connect to database?
How can I use the JDBC API to access a desktop database like Microsoft Access over the network?
What are drivers available?
What is the use of getGeneratedKeys() method in Statement?
Can you create an index on sex column where there is M or F?