Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kkk514
Starting Member
8 Posts |
 Posted - 2010-05-25 : 11:30:15
|
| Hi Experts,I have a job which rebuilds the indexes in a database in SQL 2005 and I can know when the indexes were rebuilt from the job history.However, if I run the index rebuild script through SQL query window then how can we know when the indexes were rebuild i.e, (date and time when the indexes were rebuilt in the database).Any way to know the same. Will there be any table where the details will be stored (sysindexes).Thanks in advance. |
|
|
mrl4268
Starting Member
2 Posts |
Posted - 2010-06-02 : 20:49:42
|
| One way is to run DBCC SHOW_STATISTICS(TABLENAME,INDEX_NAME) which gives you the time the index was last updated. Rebuild index updates statistics as well. MohanMohan Rao |
 |
|
|
|
|
|
Index Rebuild date and time