Multiple choice technology databases

facility Which allows you to preview how Teradata will execute a requested query.

  1. Help

  2. Run

  3. Explain

  4. complie

Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

The EXPLAIN facility in Teradata displays the execution plan for a query without actually running it. This shows how the optimizer will process the query, including join strategies, index usage, and data movement steps across AMPs. It's essential for performance tuning.