Identifying Skewed Distribution of Table Data - Teradata Database

Teradata Database Administration

Product
Teradata Database
Release Number
15.10
Language
English (United States)
Last Update
2018-10-06
Product Category
Software

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.