Shows that this is an XML index.
显示此索引为xml索引。
XISCAN (xml索引扫描)。
Provide an XML index for an XML column.
为xml列提供xml索引。
Thus, each XML index requires a target type.
因此,每个xml索引需要一个目标类型。
An XISCAN plan using the specified XML index.
一个使用指定的xml索引的XISCAN计划。
Thus, each XML index requires you to specify a target type.
因此,要求为每个xml索引指定一个目标类型。
Expanded, shows information about the properties of this XML index.
已展开,显示此xml索引的属性相关资讯。
XML index eligibility requires your attention if namespaces are involved.
需要注意xml索引合格性是否包含了名称空间。
The XML index contains at least all XML nodes that satisfy the predicate.
xml索引至少包含了满足谓词的所有xml节点。
The first XML index created on the column will be the basis of the others.
基于该列创建的第一个XML索引将成为后续索引的基础。
If the XML index is defined as double, you cast the join predicate with xs: double.
如果将xml索引定义为double,则用xs: double转换连接谓词。
If you delete the primary XML index, the secondary indexes will also be deleted.
删除主x ML索引后,二级索引也随之删除。
The first statement defines the relational index, and the second defines the XML index.
第一个语句定义关系索引,第二个语句定义xml索引。
This guideline specifies that a single XML index scan be used to access the given table.
该准则指定一个单一的xml索引扫描,将用于访问给定的表。
When the index name is not specified, optimizer picks the cheapest single XML index access plan.
如果未指定索引名,优化器将选用成本最低的XML 索引访问计划。
If specified, it requests an access plan using an XISCAN operator over this particular XML index.
如果指定了索引名的话,它将对特定的xml索引使用XISCAN操作符来请求一个访问计划。
Since DB2 9.5 you can add the optional clause REJECT INVALID VALUES to your XML index definition.
从DB 2 9.5往后,您就可以向xml索引定义添加可选的REJECTINVALIDvalues子句。
The access element further specifies that some XML index must be used to access the table CUSTACC.
ACCESS元素进一步指定必须使用某些xml索引来访问表custacc。
The XML index definition is equally or less restrictive than the query predicate (" containment ").
xml索引定义的限制等同于或低于查询谓词的限制(“容纳”)。
Then, you can define one XML index on the non-leaf element "phone" and one on the element "areacode".
然后,可以在非末端元素“phone”和元素“areacode”上分别定义一个xml索引。
The example guideline in Listing 16 specifies that some XML index be used to access the table SECURITY.
清单16中的示例准则指定必须使用一些XML索引来访问表SECURITY。
It also creates an XML index on employee office Numbers that might appear as XML elements in employee records.
它还在职员办公室编号上创建一个xml索引,这个数据可能作为XML元素在职员记录中出现。
The example guideline in Listing 21 specifies that the XML index SEC_NAME be used to access the 'SECURITY' table.
清单21中的示例准则指定将使用xml索引sec_name访问“SECURITY”表。
Index creation wizards in other tools aren't yet able to handle the definition of the XPath for XML index creation.
其他工具中的索引创建向导还不能为xml索引创建处理XPath定义。
If the XML index is defined as VARCHAR, you cast the join predicate with fn: string, and so forth as you see in Table 6.
如果将xml索引定义为VARCHAR,则用fn:string转换连接谓词,如表6所示。
To summarize the advice for XML join queries, always cast join predicates to the type of the XML index that should be used.
总结一下关于XML连接查询的建议,通常将连接谓词转换为应使用的xml索引类型。
Each XML column can have more than one XML index, but the first one created (primary) will be the basis of the others.
每个xml列均可以有多个xml索引,但是创建的第一个索引(主索引)将成为其他索引的基础。
With DB2 9.7, XML index creation allows concurrent write operations by default, just like the creation of relational indexes.
在DB 2 9.7中,与创建关系索引一样,xml索引创建操作在默认情况下允许并发的写操作。
If only one XML index is available, then DB2 cannot apply this guideline and will instead produce the cheapest alternative plan.
如果只有一个xml索引是可用的,那么DB 2将无法应用这个准则,因而将生成成本最低的替代计划。
Each XML column can have more than one XML Index, but the first one created (primary) will be the basis of the others (secondary).
每个xml列都可以有多个xml索引,但最先创建的索引(主索引)将成为其他索引(二级索引)的基础。
应用推荐