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 while rs next ())?
Why we use jdbc instead of odbc?
Is jdbc and orm?
What is meant by dao?
What is two-phase commit in the database?
How can I manage special characters when I execute an insert query?
What are the advantages of using preparedstatement over statement?
How do I load a database driver with JDBC 4.0 / Java 6?
What is the most common example type 1 driver?
What is jdbc type?
What is the use of statement in jdbc?
How to use JDBC API to call Stored Procedures?
What happens if we don't close the connection in jdbc?
What is CLOB and BLOB datatypes in JDBC?
Can I use JDBC to execute non-standard features that my DBMS provides?