您要查找的是不是：
- Table locks are applied for the duration of the index operation. 在索引操作期間應用表鎖。
- Long-term table locks are not held for the duration of the index operation. 在索引操作期間不持有長(cháng)期表鎖。
- Index page deallocation during a DROP INDEX operation is always fully logged. DROP INDEX操作期間將完整記錄索引頁(yè)的釋放操作。
- Additional temporary disk space is required during the index operation. 索引操作期間需要額外的臨時(shí)磁盤(pán)空間。
- Each query or index operation requires a certain number of threads to execute. 每個(gè)查詢(xún)或索引操作均要求一定線(xiàn)程數才能執行。
- It may be better to run index operations offline. 脫機運行索引操作可能比較好。
- Enter a time of day that the indexing operation will start on the specified start date. 輸入索引操作將在指定開(kāi)始日期開(kāi)始的時(shí)間。
- Verify that the tempdb database and transaction log have sufficient disk space to handle the index operation. 驗證tempdb數據庫和事務(wù)日志具有足夠的空間來(lái)處理索引操作。
- The Progress Report Event Category includes the Progress Report: Online Index Operation event class. Progress Report事件類(lèi)別包括Progress Report:Online Index Operation事件類(lèi)。
- During the main phase of the index operation, only an Intent Share (IS) lock is held on the source table. 在索引操作的主要階段,源表上只使用意向共享(IS)鎖。
- This allows for the transaction log of the user database to be truncated during the index operation if it is required. 這允許在索引操作期間截斷用戶(hù)數據庫中的事務(wù)日志(如果需要)。
- Table locks are applied and the table is unavailable for the duration of the index operation. 應用表鎖,該表在索引操作期間不可用。
- This could cause a decrease in performance and greater resource usage, especially CPU time, during the index operation. 這會(huì )導致在索引操作過(guò)程中性能降低和使用較多的資源,尤其是CPU時(shí)間。
- Use a database recovery model that allows for minimal logging of the index operation. 使用數據庫恢復模型,它允許對索引操作做最小的日志記錄。
- Restricts the maximum number of processors used in a parallel index operation to the specified number. 將并行索引操作中使用的最大處理器數量限制為指定數量。
- The SORT_IN_TEMPDB option may improve the contiguity of index extents, especially if the CREATE INDEX operation is not being processed in parallel. SORT_IN_TEMPDB選項可能會(huì )提高索引區的鄰接,尤其當不是并行處理CREATE INDEX操作時(shí)。
- Restricts the maximum number of processors used in a parallel index operation to the specified number or fewer based on the current system workload. 基于當前系統工作負荷,將并行索引操作中使用的最大處理器數限制為指定數量或更少。
- An offline index operation that creates, rebuilds, or drops a clustered index, or rebuilds or drops a nonclustered index, acquires a Schema modification (Sch-M) lock on the table. 創(chuàng )建、重新生成或刪除聚集索引或者重新生成或刪除非聚集索引的脫機索引操作將對表獲取架構修改(Sch-M)鎖。
- The array indexing operator cannot be overloaded, but you can define indexers. 不能重載數組索引運算符,但可定義索引器。
- When a query or index operation starts executing on multiple threads for parallel execution, the same number of threads is used until the operation is completed. 從查詢(xún)或索引操作開(kāi)始在多線(xiàn)程上并行執行起,將一直使用相同的線(xiàn)程數,直到操作完成。
