Information about the table space and index node groups or partitions.
关于表空间和索引节点组或分区的信息。
It is also profitable to separate index data from table data.
将索引数据从表数据中分离出来也是有益的。
The index partition for each data partition can be in a different table space.
每个数据分区的索引分区可以位于不同的表空间中。
Index your table columns appropriately.
适当地为表列建立索引。
Add an index to the target table.
向目标表中添加一个索引就可以了。
A: Global indexes allow the flexibility of specifying a table space for each index.
A:全局索引允许灵活地为每个索引指定一个表空间。
But, you could decide to index book prices as VARCHAR, as shown in Table 3.
但是,也可以将书籍价格作为VARCHAR进行索引,如表3所示。
Avoid having any indexes on the table, if possible, but particularly not a clustering index.
尽可能避免表上有任何索引,尤其是不要有群集索引。
Automatic table and index reorganisation.
自动表和索引重组。
Make sure that the attachment table has an appropriate index.
确定附件表格拥有一个适当的索引。
The example above shows how to fill the lock table for two full-text index resources.
上面的示例演示如何在锁表中填充两个全文索引资源。
The Times taken to create and optimize the index are shown in Table 2.
创建和优化索引所花费的时间如表2中所示。
These locks could be table level, row level, or lock on index, and so on.
这些锁可以是表级锁、行级锁、索引锁等等。
Index creation on a table that contains data.
在包含数据的表上创建索引。
Example: Create a partitioned table and a partitioned index.
示例:创建已分区表和已分区索引。
Each line is a runstats command on a table or index.
每一个行是一个表或索引上的runstats命令。
Storing multiple table or index fragments in a single dbspace.
在单个dbspace中存储多个表或索引片段。
tcbstats all Show all table and index metrics
tcbstats all显示所有表和索引度量指标
To evaluate the new access plan after the index creation on the ACCOUNT table issue.
为了在account表上创建索引之后评估新的访问计划,要发出。
Use the following command to view the existing index on a particular table.
使用以下命令查看一个特定表已有的索引。
This basic table simply loops through our list of images starting at index number $limit_start.
这个表很简单,它从索引号 $limit_start开始遍历图片列表。
Reduce the number of extents of the table or index space.
缩小表或索引空间的规模。
In addition, Deep Compression was used to compress both table and index data.
此外,DeepCompression则被用于压缩表和索引数据。
There is no index on customer_number in the bills table.
在账单表中不存在customer_number上的索引。
Is the whole table scanned or is it accessed by an index?
是否扫描了整个表或是否由索引访问?
Note that only the table data pages and not the index pages are sampled.
请注意,只对表数据页进行抽样,而不是索引页。
Q: How can I tell if an index on a partitioned table is partitioned?
Q:我如何能辨别已分区表上的索引是否被分区?
An index is an ordered set of Pointers to rows in a base table.
索引是一个指向基础表的有序指针集。
Replicating an index does not require a lock on the table.
复制索引不需要锁定表。
Look at an example of adding an index to your CUSTOMER table.
我们以在customer表中添加索引为例。
应用推荐