Identifying Skewed Distribution of Table Data - Teradata Database

Teradata Database Administration

Teradata Database
Release Number
English (United States)
Last Update
Product Category

Identifying Skewed Distribution of Table Data

You can do the following to identify uneven row distribution:

  • Check space usage using Teradata Viewpoint. See “Using Teradata Viewpoint to Find Skewed Tables” on page 497.
  • Run the ResVproc macro to check the AMP parallel efficiency so that you can identify the AMP affecting that node. See Resource Usage Macros and Tables.
  • Check table distribution information at the AMP level by running an SQL query against DBC.TableSizeV. See “Finding Skewed Tables by Querying the TableSizeV View” on page 179.
  • Check hash distribution among AMPs. See “Finding Uneven Distribution Using Hash Functions” on page 497.