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 |
|
na2173
Starting Member
38 Posts |
 Posted - 2004-01-29 : 15:47:01
|
| Is there any query that tells me if the index was rebuild and also the date when the index was rebuild |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-01-29 : 16:17:34
|
| If the index was rebuilt using the drop and create way, then the index would have a create date in the system tables. Not sure about DBCC DBREINDEX though. But what does it matter? I ask because you need to rebuild an index if it becomes fragmented. To check this, you run DBCC SHOWCONTIG.Tara |
 |
|
|
|
|
|
When was the lasttime the index was Rebuild