How can you tune SQL statements?
Answers were Sorted based on User's Feedback
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 |
How many types of JDBC Drivers are present and what are they?
How do I stop nullpointerexception?
What are the measures to connect to the db using jdbc?
wahts is mean by primary key and unique key?
What are the steps to connect to a database in java?
Is jdbc faster than hibernate?
Explain about column name and getter method?
What is preparedstatement in jdbc?
preparedstatement p= new preparedstatement is it possible ?
10 Answers Fidelity, IBM, Infrasys,
How can you retrieve data from the resultset using jdbc?
What is layer in communication?
Where can I find ojdbc14 jar file?