I recently dropped 90% of a big table that had a dozen indexes. When I did a SP_SPACEUSED on the table, it told me that the index size was 2.1 gigs but there were only 90 megs of data (139000 rows). What can I do to reinitialise the indexes so that the space they occupy reflects the new amount of data in the table? I tried updating statistics and shrinking the DB but it doesn't do any good. Any comment would be appreciated.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
TRIMMING DOWN INDEXES
- Thread starter sebpas
- Start date
tlbroadbent
MIS
Or run DBCC DBREINDEX. See SQL BOL for details. If you ahve a clustered index just rebuild that ans all other will be rebuilt automatically. Terry L. Broadbent - DBA
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.
Computing Links:
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question