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
Why is odbc needed?
There is a method getColumnCount in the JDBC API. Is there a similar method to find the number of rows in a result set?
What are the differences between resultset and rowset?
How can you make a connection?
Jdbc-odbc bridge is multi-threaded or not?
What is com mysql jdbc driver?
Is jdbc a web technology?
How can we retrieve data from the resultset?
Which database is used for java?
How can I know when I reach the last record in a table, since JDBC doesn't provide an EOF method?
How we store procedure in oralce for callable statements in jdbc
What is jdbc driver for sql server?
What is dburl?
What is the full form of jdbc and what is its purpose?
What is an advantage of using the jdbc connection pool?