Teradata Cookbook

There's more...

• You should run an EXPLAIN for a query with multiple Joins especially if joining columns are non-index columns
• Look for high estimated runtime's (more than one to three hours) or a large row count (several hundred million to billions in the case of large tables)
• If estimated rows don't match your expected row count, especially if they are exponentially high, don't execute a query before attempting to optimize it
• The explain plan of an executing query can be checked from the Viewpoint interface at the time of running
• The DBQLExplainTbl table in the DBC database holds the explain text of already executed queries. The DBQL ruleset to collect the execution plan needs to be enabled to store data in this table.
• Check for partition ...