如,索引通常是用一张单独的页面列出字母表索引。
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.
关于表空间和索引节点组或分区的信息。
Information about the table space and index node groups or partitions.
该脚本创建一个包含关于表和索引使用的细节的报告。
The script creates a report that provides details about table and index usage.
恢复所有不同的类型,然后恢复所有表及其索引。
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.
它包含表、索引、表空间和缓冲池的控制块信息。
It contains control block information for tables, indexes, table Spaces, and buffer pools.
书的最后一部分包括附录、术语表和索引。
The last section of the book includes the appendices, the glossary, and an index.
目前的CTP 1仅支持表、索引和约束。
创建表和索引。
应当有多个磁盘用于DB 2日志、表和索引。
There should be multiple disks for the DB2 logs, for tables, and for indexes.
在单个dbspace中存储多个表或索引片段。
Storing multiple table or index fragments in a single dbspace.
tcbstats all显示所有表和索引度量指标
表和索引可以驻留在不同的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.
缩小表或索引空间的规模。
nindexes -表中索引的数量。
从前面的例子中可以看到,智能统计对于所有表和索引都是通用的,不管是否是片段表或索引。
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.
应用推荐