15.00 - Problem Statement - Teradata Database

Teradata Database Design

prodname
Teradata Database
vrm_release
15.00
category
User Guide
featnum
B035-1094-015K

Problem Statement

The current definition of the call detail table does not use a partitioned primary index:

     CREATE TABLE calldetail (
       phone_number        DECIMAL(10) NOT NULL,
       call_start          TIMESTAMP,
       call_duration       INTEGER,
       call_description    VARCHAR(30))
     PRIMARY INDEX (phone_number, call_start);

Can the standard query workloads against this table be optimized by partitioning its primary index?