Volatile Tables And Statistics

Database
Enthusiast

Volatile Tables And Statistics

Am I correct in thinking that you can't collect statistics on VTs in TD12 ?

I thought I'd read you could but the manuals say you can't.

Thanks

2 REPLIES
Enthusiast

Re: Volatile Tables And Statistics

Statistics cannot be collected on a Volatile table.

From Teradata Documentation:

5341 Volatile table "%VSTR" not allowed in
statement.

Explanation: The user submits a statement that is not
allowed to access a volatile table. Currently, volatile
tables are not allowed to be referenced in the following
statements/utilities:

Collect/Drop Statistics Alter Table Grant/Revoke
Locking statements Fastload Multiload

Generated By: RES modules.

For Whom: End User.

Remedy: Don't use volatile table in current statement.
Enthusiast

Re: Volatile Tables And Statistics

You can collect stats on global temporary tables. If your SQL and volatile table usage would benefit from statistics being present, you may want to consider switching to global temporary tables instead.