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 / khalid moin

try to use function based indexes and use it when needed..
it will not be used unnecessorily.

use clustering concept while creating table it will make you
join operation fast if more join operation u r going to
perform on the tables

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to convert a unicode strings to non-unicode strings?

1029


List types of tables in SQL Azure?

126


How exceptions can be handled in sql server programming?

951


how to do partition in sqlserver

2408


Does partitioning help performance?

888


What is order of B+tree?

1061


How to create a ddl trigger using "create trigger" statements?

1068


What is the difference between join and inner join?

952


How you can minimize the deadlock situation?

979


What stored by the model?

981


what are acid properties? : Sql server database administration

928


Explain triggers?

942


Do you know what is blocking?

899


What is sharding?

114


How to delete duplicate rows in sql server?

1056