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...

What are the factors you will check for the performane
optimization for a database query?

Answer Posted / pushpendra kumar

The important factors for performance optimization are as
follows:
1. Proper data type assignment;
2. Selection of proper data reader;
3. Proper command to retrieve the data from the database.

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is in place upgrade in sql server?

1091


Explain trigger and its types?

1114


What do you mean by a dependent functionality in a build?

1195


How can we remove orphan records from a table?

1027


How to run sql server 2005 books online on your local system?

999


How to create an inline table-valued function?

1019


Explain error and transaction handling in sql server?

1060


What is “asynchronous” communication in sql server service broker?

1075


What is the current pricing model of SQL Azure?

104


what happens on checkpoint? : Sql server database administration

1156


what are acid properties? : Sql server database administration

1056


What is a periodical index?

973


What are the reporting services components?

144


How do I create an extended event in sql server?

1001


What is indexed view?

1022