Random AMP Samples - System Emulation Tool

Teradata System Emulation Tool User Guide

Product
System Emulation Tool
Release Number
16.10
Published
May 2017
Language
English (United States)
Last Update
2018-05-07
dita:mapPath
lth1488824663584.ditamap
dita:ditavalPath
Audience_PDF_include.ditaval
dita:id
B035-2492
lifecycle
previous
Product Category
Teradata Tools and Utilities

Select the Random AMP Samples check box to export the data distribution of a table on one or more randomly selected AMPs based on the type of export operation.

When exporting by query, this option exports the RAS for the tables referenced by the specified queries.

When exporting by database, this option exports the RAS of the tables selected for export.

When exporting by workload, this option exports the RAS for the tables referenced by the workload queries.

TLE must be turned on before setting RAS. Be aware that TLE might cause system performance degradation. For more information on TLE, refer to SQL Request and Transaction Processing (B035-1142).