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 while rs next ())?

1002


Why we use jdbc instead of odbc?

1035


Is jdbc and orm?

986


What is meant by dao?

999


What is two-phase commit in the database?

1109


How can I manage special characters when I execute an insert query?

987


What are the advantages of using preparedstatement over statement?

1076


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

1029


What is the most common example type 1 driver?

1079


What is jdbc type?

940


What is the use of statement in jdbc?

986


How to use JDBC API to call Stored Procedures?

1063


What happens if we don't close the connection in jdbc?

926


What is CLOB and BLOB datatypes in JDBC?

1401


Can I use JDBC to execute non-standard features that my DBMS provides?

1067