How can you tune SQL statements?

Answer Posted / balakrishna

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is resultsetmetadata?

670


What is an advantage of using the jdbc connection pool?

659


How can we move the cursor in a scrollable result set?

721


Explain the importance of drivermanager.

913


How do you insert images into database using jdbc?

798


How can I determine where a given table is referenced via foreign keys?

739


Where can I find ojdbc14 jar file?

698


How many types of jdbc drivers are there?

741


What is the meaning of connection?

738


What is JDBC API and when do we use it?

755


Is possible to open a connection to a database with exclusive mode with JDBC?

733


What is setautocommit in jdbc?

656


What are the advantages of using preparedstatement in java?

739


List the advantages of using datasource?

762


What is jdbc connection class?

654