15.00 - Approaches to Filling Out the Table Form - Teradata Database

Teradata Database Design

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

Approaches to Filling Out the Table Form

Because the determination of data demographics for columns that will be treated as multicolumn indexes is far more complex than the determination of similar data for single column index columns, the sample analysis and the way you fill out the Table form differs slightly for the single column and multicolumn situations.

The following table points to the Table form topics that apply to the two situations:

 

Topic

 

Applies to Single Column Data?

Applies to Multicolumn Data?

“Table Form”

             Yes

             Yes

“Table Form: Basic Information”

             Yes

             Yes

“Table Form: Column-Level Information”

             Yes

             Yes

“Table Form: Miscellaneous Column‑Level Information”

             Yes

             Yes

“Table Form: Access Information”

             Yes

             Yes

“Table Form: Data Demographics for Single‑Column Database Objects”

             Yes

             No

“Maximum and Typical Column Value Frequencies”

             Yes

             Yes

“Table Form: Data Demographics for Multicolumn Database Objects”

             No

             Yes