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 how the jdbc application works.
What is jdbc architecture?
What are clob and blob data types in jdbc?
Explain creation of statement object with connection method create method with help of an example.
What are the different classes through which JDBC represents statements?
What are the standard isolation levels defined by JDBC?
What is jdbc? Describe the steps needed to execute a sql query using jdbc.
How many rowset are available in jdbc?
explain about special characters?
What is meant by connection string?
What is JDBC Connection? Explain steps to get Database connection in a simple java program.
What causes the "No suitable driver" error?