您要查找的是不是:
- 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. 在索引操作期间不持有长期表锁。
- Index page deallocation during a DROP INDEX operation is always fully logged. DROP INDEX操作期间将完整记录索引页的释放操作。
- Additional temporary disk space is required during the index operation. 索引操作期间需要额外的临时磁盘空间。
- Each query or index operation requires a certain number of threads to execute. 每个查询或索引操作均要求一定线程数才能执行。
- 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. 输入索引操作将在指定开始日期开始的时间。
- Verify that the tempdb database and transaction log have sufficient disk space to handle the index operation. 验证tempdb数据库和事务日志具有足够的空间来处理索引操作。
- The Progress Report Event Category includes the Progress Report: Online Index Operation event class. Progress Report事件类别包括Progress Report:Online Index Operation事件类。
- 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. 这允许在索引操作期间截断用户数据库中的事务日志(如果需要)。
- 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. 这会导致在索引操作过程中性能降低和使用较多的资源,尤其是CPU时间。
- 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选项可能会提高索引区的邻接,尤其当不是并行处理CREATE INDEX操作时。
- 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. 创建、重新生成或删除聚集索引或者重新生成或删除非聚集索引的脱机索引操作将对表获取架构修改(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. 从查询或索引操作开始在多线程上并行执行起,将一直使用相同的线程数,直到操作完成。
- 今日热词
-
- 深远海浮式风电平台 - deep-sea floating wind power platform
-
- 京雄高速公路 - Beijing-Xiongan expressway
-
- 农业及相关产业增加值 - the added value of agriculture and related industries