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 Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone)>
Public ReadOnly Property SpaceUsed As Double

Property Value

Type: System.Double

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

System_CAPS_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.

Return to top
Show: