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
What is a statement?
Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?
What are the factors that the jdbc driver performance depends upon?
Why do we need jdbc?
Why resultset is used in java?
What are common JDBC Exceptions?
What is JDBC PreparedStatement?
Why do I get UnsatisfiedLinkError when I try to use my JDBC driver?
Explain the life cycle of jdbc.
What is the difference between setmaxrows(int) and setfetchsize(int)?
Does jdbctemplate close connection?
What are the basic exceptions in jdbc?
What is jdbc and odbc?
What is executeupdate in java?
What are four types of JDBC driver?