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?

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

What is database deadlock ?

1081


Why would you use setautocommit(false) in jdbc?

1141


Why jdbc is used in java?

900


What is jdbc and jdbc drivers?

942


What is the limitation of PreparedStatement and how to overcome it?

1099


Is jdbc a protocol?

886


Once I have the Java 2 SDK, Standard Edition, from Sun, what else do I need to connect to a database?

955


What is the return type of execute, executequery and executeupdate?

1073


Describe how the jdbc application works.

977


What are the components of jdbc?

949


What are the different types of locking in JDBC?

964


What are the steps to connect to a database in java?

893


Under what circumstances, that all four drivers are used?

2374


What is jdbc and jpa?

931


What is an odbc driver?

862