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...


How can you tune SQL statements?

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

How do I find whether a parameter exists in the request object?

0 Answers  


Which type of driver is unique in jdbc?

0 Answers  


Is java a database?

0 Answers  


How does JDBC API helps us in achieving loose coupling between Java Program and JDBC Drivers API?

0 Answers  


Can I get a null resultset?

0 Answers  


What is thin driver in jdbc?

0 Answers  


What is the major difference between java.util.date and java.sql.date data type?

0 Answers  


What are different types of JDBC Drivers?

0 Answers  


what is the current version of JDBC? and explain its features?

3 Answers  


what is meant by connection pooling?

4 Answers  


What is jdbc dialect?

0 Answers  


What is ojdbc14 jar?

0 Answers  


Categories