Interested to Buy Any Domain ? << Click Here >> for more details...
How can you tune SQL statements?
- 2 Answers
- 6379 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 |
What is an escape syntax?
How many isolation levels are supported in JDBC and what are they?
What is <discriminator > in Hibernate? How exactly inheritance of Object to Tables can be done? What is the benefits of discriminator?
What is meant by jdbc and odbc?
what are design patterns?
How can you use preparedstatement in jdbc?
What is resultset in jdbc with example?
How can I use the JDBC API to access a desktop database like Microsoft Access over the network?
Differentiate between type_scroll_insensitive and type_scroll_sensitive.
What is hbm xml?
Is jdbc a web technology?
How can we store and retrieve images from the database?
Core Java 
