Index.FillFactor Property
Gets or sets the percentage of an index page to fill when the index is created or re-created.
Namespace: Microsoft.SqlServer.Management.Smo
Assembly: Microsoft.SqlServer.Smo (in microsoft.sqlserver.smo.dll)
Syntax
'Deklaracja
<SfcPropertyAttribute(SfcPropertyFlags.ReadOnlyAfterCreation)> _
Public Property FillFactor As Byte
[SfcPropertyAttribute(SfcPropertyFlags.ReadOnlyAfterCreation)]
public byte FillFactor { get; set; }
[SfcPropertyAttribute(SfcPropertyFlags::ReadOnlyAfterCreation)]
public:
property unsigned char FillFactor {
unsigned char get ();
void set (unsigned char value);
}
/** @property */
public byte get_FillFactor ()
/** @property */
public void set_FillFactor (byte value)
public function get FillFactor () : byte
public function set FillFactor (value : byte)
Property Value
A Byte value that specifies proportion of the index page to fill, in percent.
Remarks
Uwaga
For indexes based on the UserDefinedTableType object the value of FillFactor value is provided by sys.indexes and the value of FillFactor property is ignored.
Thread Safety
Any public static (Shared in Microsoft Visual Basic) members of this type are thread safe. Any instance members are not guaranteed to be thread safe.
Platforms
Development Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
Target Platforms
For a list of the supported platforms, see Hardware and Software Requirements for Installing SQL Server.
See Also