在设计teradata主索引时典型的错误是仅仅合并列来在TeradataAMPs中均匀地分布数据。
A typical mistake in designing a Teradata Primary Index is to simply combine a number of columns to evenly distribute data across Teradata AMPs.
配置文件数据并识别主索引(Primary Index,PI)候选者。
如果数据库设计者已在表上创建了主分区索引，那么查询应当与分区列结合。
If the database designer has created a Primary partition Index on a table, queries should incorporate the partitioning column.
因为db2缓冲池是系统主内存的一部分，DB 2数据库管理器在它读取或写入磁盘介质时将它分配给缓存表和索引数据。
Since a DB2 buffer pool is a part of the main memory of the system, the DB2 database manager allocates it for caching tables and index data when it reads or writes to and from media disks.
主索引是teradata数据库的惟一特性—在避免索引相关额外开销的情况下提供索引的优势。
A primary index is a unique feature of Teradata's database - it offers the benefit of an index without the traditional overhead associated with an index.
操作数据库是为已知的任务和负载设计的，如使用主关键字索引和散列，检索特定的记录，和优化“罐装的”查询。
An operational database is designed and tuned from known tasks and workloads, such as indexing and hashing using primary keys, searching for particular records, and optimizing "canned" queries.
采用多个数据文件时，主数据文件用于存储系统对象和表，次要数据文件用于存储用户数据和索引。
When using many data document, advocate data file is used at storage system object and watch, secondary data file is used at memory user data and index.
采用多个数据文件时，主数据文件用于存储系统对象和表，次要数据文件用于存储用户数据和索引。
When using many data document, advocate data file is used at storage system object and watch, secondary data file is used at memory user data and index.
应用推荐