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 can you know about drivers and database information ?

0 Answers  


what is the best way, in terms of performance, to do multiple insert/update statements, a PreparedStatement or Batch Updates?

2 Answers  


What do you mean by jdbc batch processing and what are the advantages of using jdbc batch processing?

0 Answers  


What is url in jdbc connection?

0 Answers  


What is the difference between ExecuteUpdate and ExecuteQuery?

1 Answers   Exilant,


What are the Isolation level in JDBC transaction?

1 Answers  


Does multiple concurrent open statements per connection are supported by the JDBC-ODBC Bridge?

2 Answers  


What are the ddl statements?

0 Answers  


what is CallableStatement and what is its usage?

1 Answers  


How do we load the drivers?

0 Answers  


What is an outer join?

3 Answers   Infogain,


Are all the required JDBC drivers to establish connectivity to my database part of the JDK?

0 Answers  


Categories