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 |
How do I find whether a parameter exists in the request object?
Which type of driver is unique in jdbc?
Is java a database?
How does JDBC API helps us in achieving loose coupling between Java Program and JDBC Drivers API?
Can I get a null resultset?
What is thin driver in jdbc?
What is the major difference between java.util.date and java.sql.date data type?
What are different types of JDBC Drivers?
what is the current version of JDBC? and explain its features?
what is meant by connection pooling?
What is jdbc dialect?
What is ojdbc14 jar?