Interested to Buy Any Domain ? << Click Here >> for more details...
How can you tune SQL statements?
- 2 Answers
- 6546 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 does jdbc stand for?
Why prepared statements are faster?
What do you mean by two phase commits?
What is the difference between Union, Unionall ?
What is a lock in jdbc?
How to create Connection interface object because it is Interface , Interface is not instansiated?
How do java applications access the database using jdbc?
I have the choice of manipulating database data using a byte[] or a java.sql.blob. Which has best performance?
Explain the process of creating tables using NetBeans IDE?
Explain about the drive manager class working?
What is resultset in jdbc with example?
What is the use of setFetchSize() and setMaxRows() methods in Statement?
Core Java 
