How to do it...

  1. Identify the query for which you want to check the explain.
  2. It is recommended to check the explain of all the queries before executing, as query plans get changed if table demographics are changed.
  3. Hit F6 by selecting the query to get the explain, or write the EXPLAIN keyword before the query and press F5:
ExplainInsert  Into  test01.webclicks select * From    au.az_clicks;
  1. The explain plan will be generated in the result set window.

Get Teradata Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial