Interested to Buy Any Domain ? << Click Here >> for more details...
How can you tune SQL statements?
- 2 Answers
- 6381 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 |
How can you know about drivers and database information ?
what is the best way, in terms of performance, to do multiple insert/update statements, a PreparedStatement or Batch Updates?
What do you mean by jdbc batch processing and what are the advantages of using jdbc batch processing?
What is url in jdbc connection?
What is the difference between ExecuteUpdate and ExecuteQuery?
What are the Isolation level in JDBC transaction?
Does multiple concurrent open statements per connection are supported by the JDBC-ODBC Bridge?
What are the ddl statements?
what is CallableStatement and what is its usage?
How do we load the drivers?
What is an outer join?
Are all the required JDBC drivers to establish connectivity to my database part of the JDK?
Core Java 
