Table Space Report Contents - Teradata Administrator

Teradata Administrator User Guide

Product
Teradata Administrator
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
dita:id
B035-2502
lifecycle
previous
Product Category
Teradata Tools and Utilities

Table Space Report Contents

Note: The actual column headings are a function of the database itself.

 

Table 44: Table Space Report 

Field or Control

Description

Table Name

Name of each table in the selected database.

Type

Type of object

T = Table

Note: Although the item type shows as Table, the actual object might, in fact, be a Join Index or Stored Procedure. Because of this, some functions (for example, Browse) might fail if such an item is selected.

Current Perm

Amount of permanent disk space, in bytes, that is currently in use by each table in the selected database.

Peak Perm

Highest amount of permanent disk space, in bytes, that has been used by each table in the selected database.

Skew Factor

A measure of data distribution across the AMPs for the selected table.

A 'perfectly' distributed table (same amount of data on each AMP) has a Skew of 0. A table which has all the data on one AMP has a Skew of 100.

Note: Use the Space by AMP selection on the Object menu for a detailed distribution report.