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 report snapshot?

163


What does indexation mean?

1033


What is sql injection and why is it a problem? : sql server security

1188


Can primary key be null?

986


What are the two authentication modes in sql server?

1170


What is user defined datatypes and when you should go for them?

1073


What are the aggregate and scalar functions?

1137


What is difference between rownum and row_number?

1025


What is an inner join?

1041


Explain nested stored procedure. Syntax and an example for create nested stored procedure?

979


what is memory-optimized nonclustered indexes

1065


What do you mean by sql server 2005 express management tools?

1358


Which is faster statement or preparedstatement?

1003


What is the difference between having clause and where clause in sql server?

1170


How to view existing indexes on an given table using sp_help?

1207