O'Reilly logo

Tera-Tom's 1000 page e-Book on Teradata by Tera-Tom Coffing

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required