Access plan directives that force the optimizer to use the designated access method for data retrieval, either sequential scan or index scan.
访问计划指示,强制优化器使用指定的访问方法进行数据检索,要么是连续扫描,要么是索引扫描。
In the previous section you learned about one type of access method, index scan (IXSCAN), and one type of join method, nested loop join (NLJOIN).
在之前的部分您已经了解了一种类型的访问方法,即索引扫描(IXSCAN),和一种类型的联接方法,即嵌套循环联接(NLJOIN)。
An operator class is used in conjunction with the access method to specify the operators used for building the index and during query optimization.
将操作符类与访问方法结合使用,可以指定创建索引和优化查询时使用的操作符。
In this example we show you how to create a functional index that USES the R-Tree access method.
在本例中,我们将向您展示如何创建使用r - Tree访问方法的函数索引。
Since the data is spatial, you need to specify the R-Tree access method for this index.
由于涉及到空间数据,您需要为这个索引指定r - Tree访问方法。
Example: Functional index using R-Tree access method.
示例:使用r - Tree访问方法的函数索引。
In order to establish efficient access path, the authors put forward a structure index for XML data, and introduce a method of implementing operations based on.
为了建立高效地访问路径提出了一种XML数据的结构索引,并介绍了利用结构索引实现基本的数据操作的方法。
In order to establish efficient access path, the authors put forward a structure index for XML data, and introduce a method of implementing operations based on structure index.
为了建立高效地访问路径提出了一种XML数据的结构索引,并介绍了利用结构索引实现基本的数据操作的方法。
In order to establish efficient access path, the authors put forward a structure index for XML data, and introduce a method of implementing operations based on structure index.
为了建立高效地访问路径提出了一种XML数据的结构索引,并介绍了利用结构索引实现基本的数据操作的方法。
应用推荐