Not even after purging the data ? Shouldnt a lower density of data result in
a sparser index ?

"Jay Aymond" <jaymond@communitycoffee.com> wrote in message
news:BbWcnaTYYtKu59uiXTWJkw@eatel.net...
> The only way to reduce the space used by the indexes is to drop and
recreate
> them. Running update statistics will not change the size of your tables
or
> your indexes.
>
>
> "Jack A" <jacka8@excite.com> wrote in message
> news:1532eb7213031d5a2d8c8a866f3b1d15@news.teranew s.com...
> > Whats the best way to make sure you dont run out of space on your
machines
> ?
> > I've set up some purge scripts which will purge a lot of old data on our
> > system. That will free up space in the data dbspace and its
corresponding
> > chunk. But I see that the index dbspace and its chunk are very close to
> > getting full. Is the only way to manage this to add an extra chunk ?
Will
> > purging data and running update stats medium shrink the indexes too ?
> >
> > TIA
> >
> >
>
>