在设计teradata主索引时典型的错误是仅仅合并列来在Teradata AMPs中均匀地分布数据。

A typical mistake in designing a Teradata Primary Index is to simply combine a number of columns to evenly distribute data across Teradata AMPs.

youdao

配置文件数据并识别主索引(Primary Index, PI)候选者。

Profile data and identify Primary Index (PI) candidates.

youdao

如果数据库设计者已在表上创建了主分区索引，那么查询应当与分区列结合。

If the database designer has created a Primary partition Index on a table, queries should incorporate the partitioning column.

youdao