Media preference can be specified for an index or keyed file to request that the underlying index object be allocated on SSD storage.
媒介首选项可以针对索引或键控文件指定,请求将底层索引对象分配到SSD存储设备。
Typically, a non-matching index scan is chosen by the optimizer when the underlying index provides benefits such as index-only access, avoids sort, or some similar benefit.
通常情况下,在基础索引提供好处(如唯一索引访问、避免排序或一些类似的好处)时,可通过优化器选择非匹配索引扫描。
Besides reorganizing one or more indexes, large object data types (LOBs) that are contained in the clustered index or underlying table are compacted by default when an index is reorganized.
重新组织索引时,除了重新组织一个或多个索引外,默认情况下还将压缩聚集索引或基础表中包含的大型对象数据类型(lob)。
应用推荐