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

Can the JDBC-ODBC Bridge be used with applets?

2 Answers  


Which interface handles transaction management in jdbc?

0 Answers  


How does jdbc connect to database?

0 Answers  


What is the latest version of JDBC? What new features are added?

4 Answers  


What types of DataSource objects are specified in the Optional Package?

0 Answers  






How can I get information about foreign keys used in a table?

0 Answers  


What does jdbc stand for?

0 Answers  


Can you define a foreign key, with a key from the same table?

2 Answers   IBM,


What is a jdbc driver and how many jdbc drivers are available?

0 Answers  


What type of drivers have you used?

1 Answers  


Which database is used with java?

0 Answers  


MY code is: public class P1{ public static void main(String ar[]) { class.forName("java.lang.String"); } } errors i got are :New.java:5: error: <identifier> expected class.forName("java.lang.String"); ^ New.java:5: error: invalid method declaration; return type required class.forName("java.lang.String"); ^ New.java:5: error: illegal start of type class.forName("java.lang.String"); ^ New.java:7: error: reached end of file while parsing } ^ 4 errors HELP ME>......

3 Answers  


Categories