Skip to content

Teradata – SQL Performance Issues diagnostics 101

Basic 101 for Teradata sql performance issue:

1) Look at explain plan for the sql. eg:
explain
select * from dbc.tables;

2) For more details on explain plan and get suggestions on missing stats enable helpstats at session level and the run explain plan. eg:
diagnostic helpstats on for session;
explain
select * from dbc.tables;

3) For more detailed explain with recomendations enable verboseplain at session level and the run explain plan. eg:
diagnostic verboseexplain on for session;
explain
select * from dbc.tables;