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 database deadlock ?
Why would you use setautocommit(false) in jdbc?
Why jdbc is used in java?
What is jdbc and jdbc drivers?
What is the limitation of PreparedStatement and how to overcome it?
Is jdbc a protocol?
Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?
What is the return type of execute, executequery and executeupdate?
Describe how the jdbc application works.
What are the components of jdbc?
What are the different types of locking in JDBC?
What are the steps to connect to a database in java?
Under what circumstances, that all four drivers are used?
What is jdbc and jpa?
What is an odbc driver?