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 |
|
runnerpaul
Starting Member
24 Posts |
 Posted - 2011-07-07 : 10:41:43
|
| Hi,How do you check when tables were last indexed?CheersPaul |
|
|
RickD
Slow But Sure Yak Herding Master
3608 Posts |
Posted - 2011-07-07 : 11:35:54
|
| What do you mean by "when they were last indexed"? If there is an index on the table, everytime you insert/update or delete a record.Do you mean last time they were defragged? This is also a pointless question. You can check for index fragmentation as that is what really matters. You can use either DBCC SHOWCONTIG or use sys.dm_db_index_physical_stats |
 |
|
|
|
|
|
Indexing tables