HELPSTATS in Teradata

If you want to check whether the stats are working well for your query, then render the below query, execute EXPLAIN plan.

Code:
DIAGNOSTIC HELPSTATS ON FOR SESSION;


To get a more detailed explain plan, run the command below before executing EXPLAIN,
DIAGNOSTIC VERBOSEEXPLAIN ON FOR SESSION;