15.10 - EXPLAIN Request Modifier in Greater Depth - Teradata Database

Teradata Database SQL Request and Transaction Processing

prodname
Teradata Database
vrm_release
15.10
category
Programming Reference
User Guide
featnum
B035-1142-151K

This section examines the usefulness of the EXPLAIN request modifier in different situations.

You should always use EXPLAIN reports to analyze any new queries under development. Subtle differences in the way a query is structured can produce enormous differences in its resource impact and performance while at the same time returning the identical result set.

EXPLAIN request modifier terms are defined in “EXPLAIN Request Modifier” on page 534.