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 |
Describe odbc?
How do I stop nullpointerexception?
What are different types of JDBC Drivers?
Give a way to check that all result sets have bin accessed and update counts are generated by execute method.
how we can remove hard code in java?
How do I know which jdbc driver to use?
What is jdbc oracle thin?
Is jdbc connection secure?
How to rollback a JDBC transaction?
Does jdbc require oracle client?
What is jdbc class forname?
What is jdbc explain?