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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Can the contents of an Index be seen?

Author  Topic 

RobVG
Starting Member

42 Posts

Posted - 2004-07-08 : 18:54:13
I'm trying to visualize fragmentation and selectivity.

Are there other tools besides sp_helpindex and sp_spaceused to look at index structure?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-07-08 : 19:37:36
DBCC SHOWCONTIG

Tara
Go to Top of Page

RobVG
Starting Member

42 Posts

Posted - 2004-07-09 : 10:24:03
Thanks Tara, that does help.
Go to Top of Page
   

- Advertisement -