CODEWITHSUNDEEP
sqlteradata
BurtBee
BurtBee

Reputation: 19

Collect Stats and Explain in Teradata

I was asked to run some codes, and " to Collect Stats based on what you see in the subsequent Explain." What does it mean? Thank you.

Upvotes: 0

Views: 1103

Answers (1)

access_granted
access_granted

Reputation: 1927

diagnostic helpstats on for session;
explain
<your SQL>;

Your collect stats code will be at the bottom of the output.

Upvotes: 0

Related Questions