Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Java Related >> Java J2EE >> JDBC
  2. Suggest New Category

How can you tune SQL statements?

Question Posted / nimitha

Answers were Sorted based on User's Feedback



How can you tune SQL statements?..

Answer / pravin

may be by using preparedStatement
interface

Is This Answer Correct ?    1 Yes 0 No

How can you tune SQL statements?..

Answer / balakrishna

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

Post New Answer

More JDBC Interview Questions

What is thin driver in jdbc?

0 Answers  

What are static and dynamic queries?

1 Answers  

Discuss the procedure of retrieving warnings?

0 Answers  

What is jdbc thin client?

0 Answers  

What is the difference between setmaxrows(int) and setfetchsize(int)?

0 Answers  

What is JDBC API and when do we use it?

0 Answers  

Hi friends, In JDBC 4 drivers are there among this which driver is best and why it is best.Which driver is most commonly used in web applications.

6 Answers  

How does jdbc connect to database?

0 Answers  

How can I use the JDBC API to access a desktop database like Microsoft Access over the network?

0 Answers  

What are drivers available?

0 Answers  

What is the use of getGeneratedKeys() method in Statement?

0 Answers  

Can you create an index on sex column where there is M or F?

1 Answers   Wipro,

For more JDBC Interview Questions Click Here
Categories