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)
Syntax
'Declaration
<SfcPropertyAttribute(SfcPropertyFlags.None Or SfcPropertyFlags.Expensive Or SfcPropertyFlags.Standalone)> _
Public ReadOnly Property SpaceUsed As Double
Get
'Usage
Dim instance As Index
Dim value As Double
value = instance.SpaceUsed
[SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)]
public double SpaceUsed { get; }
[SfcPropertyAttribute(SfcPropertyFlags::None|SfcPropertyFlags::Expensive|SfcPropertyFlags::Standalone)]
public:
property double SpaceUsed {
double get ();
}
[<SfcPropertyAttribute(SfcPropertyFlags.None|SfcPropertyFlags.Expensive|SfcPropertyFlags.Standalone)>]
member SpaceUsed : float
function get SpaceUsed () : double
Property Value
Type: System.Double
An Int64 value that specifies the space used, in KB.
Remarks
Note
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.
Examples
Creating, Altering, and Removing Indexes
See Also
Reference
Microsoft.SqlServer.Management.Smo Namespace