How can you tune SQL statements?

Answers were Sorted based on User's Feedback



How can you tune SQL statements?..

Answer / pravin

may be by using preparedStatement
interface

Is This Answer Correct ?    1 Yes 0 No

How can you tune SQL statements?..

Answer / 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

More JDBC Interview Questions

What is JDBC and ODBC and what are the differences between them?

11 Answers   Idbi Bank, Infosys, Infoview, TCS,


What are the Isolation level in JDBC transaction?

1 Answers  


Give an example for getXXX method?

0 Answers  


What is jdbc url for mysql?

0 Answers  


What is jdbc driver for sql server?

0 Answers  






What is jdbc class forname?

0 Answers  


Can I set up a connection pool with multiple user IDs? The single ID we are forced to use causes problems when debugging the DBMS.

0 Answers  


Which type of driver is unique in jdbc?

0 Answers  


I have written a program to connect to database using odbc.Can this Application run on any Platform????

2 Answers  


What is the limitation of PreparedStatement and how to overcome it?

0 Answers  


can we define indexes on a foreign key? Explain pros and cons?

1 Answers  


What does the jdbc driver interface do?

0 Answers  


Categories