RebuildIndexes Method

Description

Dynamically rebuilds all indexes on the table. Calling this method does not require changes to the table constraints.

Visual Basic

Table.RebuildIndexes (
[[SortedDataType :=] tSortedDataType,]
[[FillFactor :=] lFillFactor] )

C++

HRESULT pTable->RebuildIndexes (
SQLOLE_INDEX_TYPE tSortedDataType = SQLOLEIndex_Default,
long lFillFactor = SQLOLE_USEEXISTINGFILLFACTOR );

Elements

Element	Type	Description

tSortedDataType	SQLOLE_INDEX_TYPE	Sorted data option to use. Valid values are: SQLOLEIndex_Default SQLOLEIndex_SortedData SQLOLEIndex_SortedDataReorg
lFillFactor	Long	Percent of each page that SQL Server will fill with index data when rebuilding each index. Valid values are 0 through 100.

Reference

DBCC REINDEX