Chapter 38

Collect Statistics

“The non permanent appearance of happiness and distress, and their disappearance in due course,, are like the appearance and disappearance of summer and winter seasons.”

– Bhagavad Gita

Table of Contents Chapter 38 – Collect Statistics

The Purpose of Collect Statistics

What to COLLECT STATISTICS On?

How do you know if Statistics were Collected on a Table?

The Basic Syntax for COLLECT STATISTICS

COLLECT STATISTICS Examples for a better Understanding

The Official Syntax for COLLECT STATISTICS

How to Re-COLLECT STATISTICS on a Table

How does the PE Plan if No Statistics were Collected?

How to Copy a Table with Data and the Statistics?

How to Copy a Table with NO Data and the Statistics?

When to ...

Get Tera-Tom's 1000 page e-Book on Teradata now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.