您要查找的是不是:
- CREATE STATISTICS can be executed on an indexed view. CREATE STATISTICS可以对索引视图执行。
- Is the object identification number of the table or indexed view. 表或索引视图的对象标识号。
- A view with a unique clustered index is called an indexed view. 具有唯一聚集索引的视图称为索引视图。
- The indexed view is used by the query optimizer to produce the query plan. 查询优化器使用该索引视图生成查询计划。
- Is the name of the table or indexed view for which to update statistics. 要更新其统计信息的表或索引视图的名称。
- An indexed view is a view with a unique clustered index created on it. 索引视图是包含为其创建的唯一聚集索引的视图。
- Because you intend this to be an indexed view, be sure to add only tables that you own. 由于希望这是索引视图,因此请确保只添加您自己的表。
- Indexed views have the same storage structure as clustered tables. 索引视图与聚集表具有相同的存储结构。
- Does the indexed view compute a SUM aggregate over values of type float or real? 索引视图对float或real类型的值计算SUM聚合吗?
- API cursor query contains an indexed view with a unique access path, but not at the base-table level. API游标查询包含具有唯一访问路径但不处于基表级别的索引视图。
- Transactional replication allows you to replicate an indexed view as a view or as a table. 事务性复制允许您将索引视图按视图或表来复制。
- The rows of an indexed view are stored in the database in the same format as a table. 索引视图的行以表的格式存储在数据库中。
- No other imprecise expressions can be part of the key column of an indexed view. 其他不精确表达式不能作为索引视图的键列的一部分。
- Is the name of the target table or indexed view for which statistics should be dropped. 其删除统计信息的目标表或索引视图的名称。
- Is the name or ID of the table or indexed view for which to report and correct space usage statistics. 要对其空间使用统计信息进行报告和更正的表或索引视图的名称或ID。
- A query can use an indexed view in its execution plan even if it does not satisfy these GROUP BY restrictions. 即使一个索引视图不满足这些GROUP BY限制,查询也可以在其执行计划中使用该视图。
- The order in which numbers are added during indexed view maintenance can sometimes have a generally small effect on the final result. 在维护索引视图期间添加数字的顺序有时可能会对最终结果有一点影响。
- Otherwise, statistics are derived from the underlying tables before the indexed view is substituted into the query plan. 否则,在索引视图被代入查询计划之前,从基础表派生统计信息。
- For an indexed view, drop the view, and then redefine it by using an explicit CONVERT function with a deterministic date style. 对于索引视图,请删除该视图,然后使用带有确定性日期格式的显式CONVERT函数重新定义该视图。
- If the query optimizer decides to use an indexed view in a query plan, the indexed view is treated the same way as a base table. 如果查询优化器决定使用查询计划的索引视图,则索引视图将按照基表的处理方式进行处理。