SuspendIndexing Property
В будущей версии Microsoft SQL Server эта возможность будет удалена. Избегайте использования этой возможности в новых разработках и запланируйте изменение существующих приложений, в которых она применяется.
The SuspendIndexing property controls index update when the ImportData method of the Table object is used to copy data to Microsoft SQL Server.
Синтаксис
object
.SuspendIndexing [=value]
Parts
- object
An expression that evaluates to an object in the Applies To list
- value
TRUE or FALSE
Data Type
Boolean
Modifiable
Read/write
Prototype (C/C++)
HRESULT GetSuspendIndexing(LPBOOL pRetVal);
HRESULT SetSuspendIndexing(BOOL NewValue);
Замечания
If TRUE, indexes are dropped before the bulk-copy operation is started and re-created after the bulk-copy operation is completed.
If FALSE, no changes are made to indexing.
Примечание. |
---|
Indexes that enforce referential or data integrity constraints, such as those implemented by SQL Server PRIMARY KEY or UNIQUE key constraints, are not dropped even if SuspendIndexing is TRUE. |