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 is the purpose of UPDATE STATISTICS?

Answer Posted / sambashiva

This is used after inserting huge rows into table or deleting from a table the pages of the index will be not in the proper way so by running this thing we can bring them to proper way.

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 the difference between them (ethernet networks and token ring networks)? : Sql server database administration

1055


Explain why variables called the most powerful component of ssis?

1102


How to create nested stored procedure?

1024


Explain transaction server distributed transaction?

984


What is the main purpose of having conversation group?

900


What are the grouping functions?

936


What is partition, how will you implement it? : sql server analysis services, ssas

1052


How to select true false based on column value in sql server?

1037


difference between Clustered index and non clustered index ?

996


What is 2nf example?

1000


What is a unique index?

935


What are the limitations/drawbacks or ssrs 2008 r2?

139


What do you mean by SQL injection attack?

1074


How to use “drop” keyword in sql server and give an example?

1132


Why olap is used?

977