I need to establish the storage requirements for a clustered index rebuild with SQL 05. The table is made up of the following columns
[ProductID] [int] NOT NULL,
[RegionID] [int] NOT NULL,
[TimeID] [int] NOT NULL,
[FactID] [int] NOT NULL,
[Value] [decimal](14, 4) NOT NULL
This is the clustered index :-
[RegionId] ASC,
[FactId] ASC,
[TimeId] ASC,
[ProductId] ASC
This is the result of a sp_spaceused on this particular table
The database where this table is stored is in Simple recovery mode.
What i would really like to know is, what additional storage would i require to run the following rebuild index command.
Alter Index blah on table Rebuild
Thanks
There is a nice explanation here.
WesleyB
Visit my SQL Server weblog @. http://dis4ea.blogspot.com
No comments:
Post a Comment