除了XML列路径索引之外,表中不含任何全局索引,并且
The table does not have any global indexes besides XML column path indexes, and
借助全局路径索引,可以提高存储效率,并最小化XQuery执行的路径查询时间。
The global path index results in improved storage efficiency and minimizes the path look-up time for XQuery execution.
如果已分区表包含任何xml列路径索引以外的其他全局索引,重组一个分区会导致整个表脱机。
Reorganizing a partition will put the entire table offline if the partitioned table has any global indexes besides XML column path indexes.
本文研究类层次索引、嵌套索引、路径索引和多重索引 ,并给出相应的索引维护算法。
This paper examines the class hierarchy index, nested-attribute index, path index and multiindex, and puts forward the corresponding algorithms of index maintenance.
该文分析了当前对XML数据检索的相关工作,提出了一种路径索引技术,并将之无缝结合了基于文本的倒排索引文档,以实现XML文档的内容和结构的双重检索。
This paper analyzes data retrieval of XML currently, and proposes a kind of path index technology which have been combined with inverted file to implement retrieval both on context and structure.
正如您马上就会看到的,DB 2可以使用这两个索引来为我们的查询产生一个高效的访问路径。
As you'll see shortly, DB2 can use both of these indexes to generate an efficient access path for our query.
优化程序采用系统目录,说明那里有多少行,以及构造了较好的索引来计算所采用的查询路径。
The optimizer uses system catalogs indicating how many rows there are and how well the indexes are formed to figure out what query path to use.
因为其是一个唯一索引扫描,所以在访问路径图中不显示FETCH或表节点。
There is no FETCH or table node shown in the access path graph because it is an index-only scan.
如果要使用它,你必须将其实例化,并传入用于创建索引的路径。
To use it you must instantiate it with a path that it can write the index into.
只要有可能,建议使用索引定义和查询中所需元素或属性的准确路径,而不使用通配符。
Wherever possible, it is recommended to use the exact path to the desired elements or attributes in index definitions and queries, without wildcards.
为了正确地评估这些访问路径,需要从DB 2编目中获取关于查询访问的表以及这些表上定义的索引的信息。
To properly assess these access path alternatives, you'll need information from the DB2 catalog about the tables accessed by the query and the indexes defined on those tables.
优化器使用表大小、索引可用性以及数据分布等信息来确定响应该查询的最佳路径。
The optimizer USES information such as table sizes, availability of indexes, and data distribution to figure out the optimal way to answer the query.
它高效,因为索引适合于最佳访问路径的选择。
It is efficient, as the indexes qualify for the choice of excellent access paths.
索引设计对访问路径选择至关重要。
Index design has a critical impact on access path selection.
甚至可以在xml树的特定路径上定义索引来改善性能。
Indexes can even be defined on particular paths in the XML trees to improve performance.
恰当的访问路径意味着一个索引可用并且已使用,所以该索引能够方便地对该数据进行访问。
An appropriate access path means that an index is available and used so that the index drives the access to the data.
OmniFind支持索引流文件对象中的文本数据,它使用IFS路径来标识文件。
OmniFind supports indexing text data in stream file objects, using an IFS path to identify the file.
准确而全面的统计数据能帮助生成良好的访问路径建议,当然,索引advisor工具执行时要有准确的统计数据。
Accurate and complete statistics will help drive good access path advice, and of course the index advisor should not be executed without good statistics.
为数据库配置了路径后,必须使用来自DemoNAB的信息填充索引数据库。
After you have configured the paths to the databases, you must populate the index database with information from the Demo NAB.
目前,OmniFind不支持使用IFS路径来索引流文件以外的对象类型。
OmniFind does not support using an IFS path to index object types other than stream files at this time.
在这种情况下,重新组织索引可能会影响DB2的选择,可能产生性能更好的查询访问路径。
In that case, reorganizing the index might lead to its selection as part of a better-performing query access path.
为了索引,不需要一些语法将XPath和文件系统路径区分开来,而只是将xml节点作为它本身就是个文本文件来对待。
For purposes of indexing, other than a need for a little syntax to distinguish an XPath from a file system path, I can simply treat an XML node as if it were itself a text file.
在访问路径图中,一个索引扫描通常作为一组四个节点显示在QueryTuner上。
An index scan is typically shown in Query Tuner as a group of four nodes in the access path graph.
索引没有包含更深层次的 “price”元素,表中可能存在该元素且可能与谓词路径 $i//price 相匹配。
The index does not contain "price" elements at a deeper level, which may exist in the table and are potential matches for the predicate path $i//price.
XISCAN 使用路径值对(/book/price,29) 来检查索引,并返回其中价格为 29的文档的行ID。
The XISCAN probes the index with the path-value pair (/book/price, 29) and returns the row IDs for documents where the price is 29.
查询优化器的一项新特性支持一种新的索引扫描,即索引自连接路径。
A new feature of the query optimizer supports a new type of index scan, called an index self-join path.
DB2允许在XML列上定义特定于路径的 XML索引。
DB2 enables you to define path-specific XML indexes on XML columns.
分别存储了我们需要索引的文本文件的内容和路径。
This example adds two fields named "content" and "path", which store the content and the path of the text file, respectively.
分别存储了我们需要索引的文本文件的内容和路径。
This example adds two fields named "content" and "path", which store the content and the path of the text file, respectively.
应用推荐