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 JDBC Statement?

0 Answers  

What are the different types of modifiers?

2 Answers  

What is the difference between ExecuteUpdate and ExecuteQuery?

1 Answers   Exilant,

Explain the importance of drivermanager.

0 Answers  

What are the components of jdbc?

0 Answers  

What is 2 phase commit?

0 Answers  

Is jdbc a protocol?

0 Answers  

What is jdbc odbc driver?

0 Answers  

What type of driver called is pure Java driver?

3 Answers   Vertex,

What is a rollback in jdbc?

0 Answers  

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

0 Answers  

Is there any limitation for no of statments executed with in batchupdate?

2 Answers   HSBC, IBM,

For more JDBC Interview Questions Click Here
Categories