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

What type of driver you use in real-time projects?

3 Answers  


Which database is used for java?

0 Answers  


What is metadata in programming?

0 Answers  


What is a jdbc connection pool?

0 Answers  


What are the sailent features of JDBC 2.0?

7 Answers  


What are the steps involved in establishing a connection using jdbc in java?

0 Answers  


What are the differences between execute, executequery, and executeupdate?

0 Answers  


Why we use while rs next ())?

0 Answers  


what does batchUpdate does?

6 Answers   HCL,


i am user who logined the application..after that another valid user will also logind..so that is it neccessary to create jdbc connection for each and every user...plz explain it with proper answer...plz help me

5 Answers   IBM,


How do I load a database driver with JDBC 4.0 / Java 6?

0 Answers  


What does the jdbc connection interface?

0 Answers  


Categories