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 device controller?

1062


What is the meaning of “dirty read” in the database?

1036


What is hbm xml?

876


Explain in detail about JDBC and its general features?

959


What is metadata in jdbc?

1004


What is an encrypted internet connection?

935


What is isolation level? How to set it?

2214


What is drivermanager in jdbc?

971


How will you perform truncation using JDBC?

1008


What are the types of jdbc drivers that exist?

1012


What driver should I use for scalable Oracle JDBC applications?

980


Is it possible to connect to multiple databases simultaneously? Using single statement can one update or extract data from multiple databases?

1023


How to make updates to updatable result sets in jdbc?

908


What is jdbc and explain jdbc architecture?

1018


What is the JDBC syntax for using a literal or variable in a standard Statement?

996