An index only scan is an index access that is not followed by a table access because the index itself contains all the requested data.
仅扫描索引是未包含表访问的索引访问,因为索引本身包含了所有被请求的数据。
You can define guidelines that influence only a few attributes of an execution plan, such as index specification for a certain table in the query or join order for a pair of tables.
可以定义那些只影响执行计划的某些属性的准则,比如查询中的某个表的索引说明,或者一对表的连接顺序。
As you see in Table 3, a string predicate can only be evaluated with an XML index of type VARCHAR, while a numeric predicate can only be evaluated with an index of type DOUBLE.
正如您在表3中所看到的,字符串谓词只能由varchar类型的xml索引进行计算,而数值谓词只能由double类型的索引进行计算。
应用推荐