Doubt on Update Statistics

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

raja - 25 Sep 2008 15:13 GMT

Hi,

I have the following doubts regarding update statistics.

1. I have updated the statistics of a particular table/index. Where
can i find the last date on which i have updated the statistics for a
particular table/index ?
2. If i update the statistics of a particular table, will the
statistics of that particular table's indexes will also get updated ?

Please explain in detail.

Thanks in Advance.

With Regards,
Raja.

Reply to this Message

Bret_Halford - 25 Sep 2008 17:06 GMT

> Hi,
>
[quoted text clipped - 5 lines]
> 2. If i update the statistics of a particular table, will the
> statistics of that particular table's indexes will also get updated ?

1) See the "moddate" column in the sysstatistics table

2) The docs say "If you do not specify an index name, the command
["update statistics <table>"] updates the distribution statistics for
all the indexes in the specified table. Giving an index name updates
statistics for that index only. "

Reply to this Message