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

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What are statistics, under what circumstances they go out
of date, how do you update them?

Question Posted / swapna

Answers were Sorted based on User's Feedback



What are statistics, under what circumstances they go out of date, how do you update them?..

Answer / swapna

Statistics determine the selectivity of the indexes. If an
indexed column has unique values then the selectivity of
that index is more, as opposed to an index with non-unique
values. Query optimizer uses these indexes in determining
whether to choose an index or not while executing a query.

Some situations under which you should update statistics:
1) If there is significant change in the key values in the
index
2) If a large amount of data in an indexed column has been
added, changed, or removed (that is, if the distribution of
key values has changed), or the table has been truncated
using the TRUNCATE TABLE statement and then repopulated
3) Database is upgraded from a previous version

Is This Answer Correct ?    9 Yes 0 No

What are statistics, under what circumstances they go out of date, how do you update them?..

Answer / koti

Statistics determine the selectivity of the indexes. If an
indexed column has unique values then the selectivity of
that index is more . Query optimizer uses these statistics
in determining whether to choose an index or not while
executing a query.

To update statistics there is command :

update_statistics

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More SQL Server Interview Questions

you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration

0 Answers  

Difference between drill down and drill through report.

0 Answers  

List down some advantages of sql stored procedure?

0 Answers  

How to create a simple stored procedure in ms sql server?

0 Answers  

Explain about system stored procedure?

0 Answers  

What are sql servers used for?

0 Answers  

What are the operating modes in which database mirroring runs?

0 Answers  

what is nonclustered index

0 Answers  

can i write function in stored procedure and stored procedure in function and nested procedure.Give one example for each question?

1 Answers   Cap Gemini, TCS,

In join, which clause in not used?

4 Answers   HCL, NIIT, TCS,

Can you force a query to use a specific index?

0 Answers  

what is a default tcp/ip socket assigned for sql server? : Sql server database administration

0 Answers  

For more SQL Server Interview Questions Click Here
Categories