如，索引通常是用一张单独的页面列出字母表索引。
Example, a common convention of indexes is the use of a separate Web page for each letter of the alphabet.
然而在缺乏数据分布信息的情况下，优化器将基于表索引计算不同类型筛选器的选择性。
However, in the absence of data distribution information, the optimizer will calculate selectivity for filters of different types based on table indexes.
但是，如果没有数据分布，则数据库服务器根据表索引计算不同类型的过滤器的选择率。
However, in the absence of data distributions, the database server calculates selectivity for filters of different types based on table indexes.
通常并不需要使用这个索引值，而且不会存取所有相依性属性的任何表索引。
Generally, using this index value is not required, and there is no index access to tables of all dependency properties.
正如下面解释的一样，在使用这个特性之前，要确保您已经配置了要搜索的列，并且已经正确地创建了表索引。
As explained below, be sure you have configured the search columns and properly indexed your tables before using this feature.
表索引。标准表或者排序表的最后被定位的行(表循环中当前所在行)。如果访问哈希表，则设置为0。
Table index. Last addressed line of a standard table or sorted table. Is set to 0 if hashed table is accessed.
默认情况下，不同的IBMtsom表是在默认表空间创建的，所以您应该使用另一个表空间来存储事件数据和事件表索引。
By default all the different IBM TSOM tables are created in the default table space, so you should use a separate table space for event data and event table indexes.
该脚本创建一个包含关于表和索引使用的细节的报告。
The script creates a report that provides details about table and index usage.
有了新建的索引，所有表都可以用索引扫描访问。
With the newly created indexes, all tables are accessed with index scans.
恢复所有不同的类型，然后恢复所有表及其索引。
Restore all distinct types followed by all tables with their indexes.
应用程序准备(编译)好一条语句之后，可以修改语句对象——表、索引、统计信息。
After a statement has been prepared (compiled) by the application, the statement objects — tables, indexes, statistics — can be altered.
这些对象包括模式、表空间、表、索引、视图、包、例程、序列、服务器和昵称。
These objects include schemas, table spaces, tables, indexes, views, packages, routines, sequences, servers, and nicknames.
现在来看看DB 2数据库对象(比如模式、表、索引和存储过程)的实现以及这些对象的应用程序接口。
Now turn your attention to the implementation of the DB2 database objects (such as, schema, tables, indexes, and stored procedures) and the application interface to these objects.
表空间是一个包含表、索引、大对象和长数据的存储结构。
A table space is a storage structure containing tables, indexes, large objects, and long data.
那么，确定将哪些db2表或索引放在SSD上的最佳方式是什么？
So, what's the best way to determine which DB2 tables or indexes to place on SSDs?
它包含表、索引、表空间和缓冲池的控制块信息。
It contains control block information for tables, indexes, table Spaces, and buffer pools.
目前的CTP 1仅支持表、索引和约束。
目录中不会反映这些修改，除非在这些表和索引上执行RUNSTATS。
None of these changes are reflected in the catalog, unless RUNSTATS is performed on these tables and indexes.
创建表和索引。
应当有多个磁盘用于DB 2日志、表和索引。
There should be multiple disks for the DB2 logs, for tables, and for indexes.
表和索引可以驻留在不同的dbspace中。
每个数据库对象有0到多个(0. .n)模式，每个模式可以有0到多个(0 . . n)表、索引、用户定义类型和例程等。
A database object can have zero to many (0.. n) schemas, and a schema can have zero to many (0.. n) tables, indexes, user-defined types, routines, and so on.
例如，DB 2Fundamentals考试测试考生的安全知识，表、索引和视图的创建和使用，SQL使用，以及隔离级别和锁定。
For example, the DB2 Fundamentals exam tests a candidate's knowledge of security; creating and working with tables, indexes, and views; using SQL; and isolation levels and locking.
创建表、视图、索引、触发器等的ddl语句。
Generate DDL statements for tables, view, indexes, triggers, and more.
从前面的例子中可以看到，智能统计对于所有表和索引都是通用的，不管是否是片段表或索引。
As you can see from previous example, the smarter statistics is universal to all tables and indexes regardless of whether they are fragmented or not.
物理数据库设计包括表设计、索引设计、物化查询表设计，以及其他物理数据库对象的设计。
Physical database design includes table design, index design, materialized query table design, and the design of the other physical database objects.
当根据活动表或索引空间执行时，会降低并发性和可用性。
They can reduce concurrency and availability when executed against a live table or index space.
请考虑有多行的数据库表的索引的使用。
Consider the use of indices on database tables that have many rows.
在我们对基准的第一个改进中，我们向账单表增加索引，并为表更新统计信息。
In our first improvement to the benchmark, let us add an index on the bills table and update statistics for the table.
对于索引控制的分区方法，分区的表、分区索引和群集这几个概念之间有点纠缠不清。
Under index-controlled partitioning, the concepts of partitioned table, partitioning index and clustering were all intertwined.
应用推荐