How can you tune SQL statements?
- 2 Answers
- 5501 Views
- Wipro, I also Faced
- E-Mail Answers
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 |
Why jdbc is used in java?
Explain about DSN?
What is @entity in java?
What is JDBC DataSource and what are it’s benefits?
What is jdbc connection interface?
What is resultset?
What is CLOB and BLOB datatypes in JDBC?
Explain the life cycle of jdbc.
What does executequery return in java?
how to use CallableStatement? specially how to use their index given ..
What is resultset in jdbc with example?
Why we use jdbc instead of odbc?
Core Java 
