Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
SpaceUsed Property
Collapse the table of content
Expand the table of content

Index.SpaceUsed Property

Gets or sets the disk space used to store the index data in kilobytes.

Namespace:  Microsoft.SqlServer.Management.Smo
Assembly:  Microsoft.SqlServer.Smo (in Microsoft.SqlServer.Smo.dll)

[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone|SfcPropertyFlags.Matrix)>]
member SpaceUsed : float

Property Value

Type: Double
An Int64 value that specifies the space used, in KB.

NoteNote

For indexes based on the UserDefinedTableType object the value of SpaceUsed property is zero. Also, if setting the property issues a dbcc command it will not be executed.

Community Additions

ADD
Show:
© 2015 Microsoft