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

Why is odbc needed?

863


There is a method getColumnCount in the JDBC API. Is there a similar method to find the number of rows in a result set?

993


What are the differences between resultset and rowset?

1027


How can you make a connection?

929


Jdbc-odbc bridge is multi-threaded or not?

910


What is com mysql jdbc driver?

874


Is jdbc a web technology?

844


How can we retrieve data from the resultset?

916


Which database is used for java?

904


How can I know when I reach the last record in a table, since JDBC doesn't provide an EOF method?

943


How we store procedure in oralce for callable statements in jdbc

2271


What is jdbc driver for sql server?

949


What is dburl?

945


What is the full form of jdbc and what is its purpose?

929


What is an advantage of using the jdbc connection pool?

822