Index and stats on volatile table


Index and stats on volatile table

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


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