使用XQuery查询索引表的xml列。
从属于只索引表空间的数据文件的丢失中进行恢复。
Recovering from the loss of a data file that belongs to an indexes-only tablespace.
以下例子演示了用于表的本地和全局索引表空间规范。
The following example demonstrates the table space specification for local and global indexes on the table.
增加下列结构的有效性:索引或索引分区,表或表分区,索引表。
Validate the structure of an index or index partition, table or table partition, index-organized table.
第一,虚拟索引表和字节偏移量是针对变化的时候,当虚拟机更新了。
First, table indices and byte offsets are subject to change if the VM is updated.
在搜索时,根据兴趣索引表直接将查询请求转发到有相似兴趣的节点。
When search occurs, query requests are forwarded to the peers with similar interest directly according to the interest indexical table.
利用索引表方法解决了广义操作链表对造型操作过程跟踪信息量过大的问题。
An indexing list, which we developed, is utilized to compress the large amount of information produced in the course of tracking.
由于建立了区域索引表,所以在查询时不必遍历所有的数据,提高了查询速度和效率。
Since regional index form is built, it is not necessary to go through all the data in inquiry. Inquiry speed and efficiency will be increased.
在使用ONLINE关键字时,DDL操作是在没有将排它锁应用于定义特定索引表的情况下执行的。
When you use the ONLINE keyword, DDL operations execute without applying an exclusive lock to the table on which the specified index is defined.
当你在一个索引表中存储数据时,数据的某些列同表中数据行的ROWID被拷贝进索引。
When you store data in an indexed table, certain columns of data are copied into the index alongside the rowid of the data row in the table.
一旦索引表再也无法装入内存,数据库的性能就会直线下降,所以应该尽量升级内存,以便存放那些表。
Database performance plummets once index tables don't fit in memory anymore, so scale up memory as far as possible to hold tables.
对于cust_order_header表,现有的索引表不支持表上的本地和连接谓词,如下所示。
For table CUST_ORDER_HEADER, both of the existing indexes do not support the local and join predicates on the table, as shown below.
在多分支结构的识别过程中,通过对索引表和跳转表调用指令的格式分析,提出了双特征指令匹配算法。
By analyzing the formats of calling instructions to the indexed table and the jump table, proposed a novel recognition algorithm based on character instruction matching.
在使用索引表的情况下,DB 2首先对索引表执行索引查找,然后将对应的行和包含CLOB的主表相结合。
With side tables, DB2 first performs an index lookup on the side table and then joins the corresponding row with the main table that contains the CLOBs.
查询Q3 (5predsome)具有多个谓词、使用3个索引表和主表,因此它需要计算一个4路结合。
Query Q3 (5predsome) has multiple predicates and USES three side tables plus the main table, so it needs to compute a four-way join.
QueryQ5对谓词使用索引表,但是需要提取函数(具有XML分析)来检索客户电子邮件地址。
Query Q5 uses side tables for the predicates, but requires an extract function (with XML parsing) to retrieve the customers email addresses.
通过对索引表和概率间隔区间更新条件的分析,提出了一种JPEG2000算术编码器的部分并行优化算法。
After the analysis of the updating condition for index table and probability interval, an optimized algorithm based on partial parallel scheme was presented for arithmetic encoder(AE) in JPEG2000.
图7显示查询响应时间作为表中文档数(范围从1,000到100,000)的函数(不使用索引或索引表)。
Figure 7 shows the query response times as a function of the number of documents in the table, ranging from 1,000 to 100,000 documents (when no indexes or side tables are used).
您应该在单独的一个表空间上创建索引,这样如果索引表空间出现问题,您可以直接删除该表空间,然后重要创建相同的索引。
You should create an index in a separate table space so that if something goes wrong with the index table space, you can easily drop it and then recreate the same indexes.
同时,在中心节点建立一个资源的索引表,这样就克服了原来网格系统集中式资源发现过于依赖中心服务器的缺点。
At the same time, a resource index table is established at the central node to overcome the defect of centralized resource discovery over-rely on the central server of the original grid system.
索引表能够避免许多针对 CLOB的XML解析,这通常能够使CLOB查询速度快 100倍或更多。
Side tables can avoid much of the XML parsing for CLOBs and can often make CLOB queries 100 times faster or more.
此外通过重排scnf语法规则和建立索引表对概率CYK算法进行改进,减少中间搜索步骤所需的时间以提高效率。
Besides, the search steps in probabilistic CYK algorithm is reduced and the probabilistic CYK algorithm is improved by rearranging grammar rules of SCNF and establishing the index table.
XMLExtender提供索引表的概念来加速对 XML 文档的搜索,以便避免针对谓词运算的 XML 分析。
The XML Extender offers the concept of side tables to speed up the search for XML documents in order to avoid XML parsing for predicate evaluation.
因此,使用索引和索引表通常能够缩短XML和CLOB的绝对占用时间,但是不会消除xml相对clob列较大的相对性能优势。
Thus, the use of indexes and side tables typically reduces the absolute elapsed times for both XML and CLOBs, but does not erase the large relative performance advantage of XML over CLOB columns.
如果为索引表空间使用较大的缓冲池,并且尽可能地将不同 insert排序,以便键值是排好序的,而不是随机的,就可以帮助加快索引维护。
You can help speed up index maintenance by using a large buffer pool for the index tablespace, and, if possible, ordering the inserts so that the key values are ordered, not random.
将索引数据从表数据中分离出来也是有益的。
It is also profitable to separate index data from table data.
有了新建的索引,所有表都可以用索引扫描访问。
With the newly created indexes, all tables are accessed with index scans.
该特性可以提高具有复合索引的表的查询性能。
This feature can improve query performance on tables with composite indexes.
自动表和索引重组。
这说明,在创建或删除函数索引时,执行索引的表中始终持有一个排他锁。
This means that an exclusive lock is always placed on the indexed table while a functional index is being created or dropped.
应用推荐