You can do the following to identify uneven row distribution:
- Check space usage using Teradata Viewpoint. See Using Teradata Viewpoint to Find Skewed Tables.
- 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 Example of Finding Skewed Tables by Querying the TableSizeV View.
- Check hash distribution among AMPs. See Finding Uneven Distribution Using Hash Functions.