Therefore, neither index can be used because DB2 might return incomplete results for this predicate.
由于DB 2可能为该谓词返回不完全的结果,因此两个索引均不能使用。
If DB2 used a single index range scan from 20 to 30, it would miss this document and return an incomplete query result.
如果DB 2在20到30之间使用单个索引范围扫描,则会错过该文档,并返回不完全的查询结果。
By default the 0 index would return the first section of the separated string which would be Toronto in this example.
缺省情况下,0索引将返回分隔后的字符串的第一部分,即本例中的Toronto。
应用推荐