All Forums Database
Moutusi 38 posts Joined 03/13
12 Jun 2014
Index and stats on volatile table

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

Thanks, Moutusi
Raja_KT 1246 posts Joined 07/09
12 Jun 2014

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

Raja K Thaw
My wiki:
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.