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 |
Explain the difference between inner and outer join ?
What is resultsetmetadata?
How does jdbc connect to database?
Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?
What are the standard isolation levels defined by JDBC?
What is the difference between execute, executeQuery, executeUpdate?
What is jdbc drivers in java?
Stored procedure purpose?
What is odbc. how is it related to sql cli?
How vendor Naming registry supports JNDI?
What is data source in java?
Can we have foreign key reference to a non primary key column ?