Index and stats on volatile table

Database
Enthusiast

Index and stats on volatile table

As volatile table definition does not go into DD, how Indexes and stats works on volatile table?

1 REPLY
Enthusiast

Re: Index and stats on volatile table

From "SQL Request and Transaction Processing" document, page 210

Teradata Database automatically collects session-level derived statistics for

materialized global temporary and volatile tables that are populated with data during

the current session. The system uses session-level derived statistics in the same way it

uses other derived statistics to make cardinality estimates for, and cost evaluations of,

SQL requests. These session-level statistics are maintained in the global memory for a

session and are dropped when the session logs off.

Ypu can read more there.....