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)

public:
[SfcPropertyAttribute(SfcPropertyFlags::None | SfcPropertyFlags::Expensive | SfcPropertyFlags::Standalone)]
property double SpaceUsed {
	double get();
}

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: