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.

On Sep 25, 8:13*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
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. "

On Sep 25, 8:13*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
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. "

On Sep 25, 8:13*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
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. "

On Sep 25, 8:13*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
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. "

On Sep 25, 8:13*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
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. "

On Sep 25, 8:13*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
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. "

On Sep 25, 8:13*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
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. "

On Sep 25, 8:13*am, raja <dextersu... (AT) gmail (DOT) com> wrote:
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. "