Monday, December 19, 2011

What are the options not available for volatile tables in teradata ?

The following options are not available for volatile tables because table definition is not stored in data dictionary
- Default values for columns 
- Title clause for columns
- Named Indexes for table
- Compression on columns/table level since table data are spooled
- Stats cannot be collected since data is materialized only for session 
- Identity columns as these again would need entry in IDcol tables
- PPI cannot be done on tables
- Any kind of constraints like check/referential cannot be applied on table

1 comment:

  1. Small Correction...In Teradata 13 version we have the option to collect statistics on VT table..
    S.Banerjee

    ReplyDelete