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
Can I use JDBC to execute non-standard features that my DBMS provides?
What are the differences between setmaxrows(int) and setfetchsize(int)?
What happens if connection is not closed in jdbc?
Explain the various types of locking system in jdbc?
In which ways is driver class is registered with drive manager?
State the different connection methods used for creating different types of sql.
What is jdbc architecture in java?
How can we store the file in the oracle database?
Discuss the procedure of retrieving warnings?
What is database deadlock ?
How to retrieve warnings in jdbc?
What is an SQL Locator?
password, is stored in as plain text. What can I do to protect my passwords?
What are the advantages of collection pools?
What is jdbc driver?
