TeraTeam UK Teradata DBA Definition
Explain (plan):
The 'Explain' plan is effectively the plan that the Teradata optimiser uses to perform a submitted query request. It is called the 'Explain' plan as the keyword 'Explain' is used in the command executed by the user to display the optimiser plan. e.g. EXPLAIN SELECT * FROM MyTable;
The Explain plan is used by the Teradata Active Systems Management (TASM) utility to manage the resources allocated to user queries.
