Tables - Advanced SQL Engine - Teradata Database

• Is a type of temporary table obtained from one or more other tables as the result of a subquery.
• Is specified in an SQL SELECT statement.
• Avoids the need to use the CREATE and DROP TABLE statements for storing retrieved information.
• Is useful when you are coding more sophisticated, complex queries.

• Store information about errors on an associated permanent table.
• Log information about insert and update errors.

• Are private to the session.
• Are dropped automatically at the end of a session.
• Have a persistent table definition stored in the Data Dictionary. The saved definition may be shared by multiple users and sessions with each session getting its own instance of the table.

• Store trace output for the length of the session.
• Have a persistent table definition stored in the Data Dictionary.
• Are useful for debugging SQL stored procedures (via a call to an external stored procedure written to the trace output) and external routines (UDFs, UDMs, and external stored procedures).

They provide a performance advantage when used as staging tables to load data from FastLoad or TPump Array INSERT.

They can have secondary indexes defined on them to avoid full-table scans during row access.

• Are permanent tables with a timestamp column. The timestamp indicates when each row was inserted into the table.
• Establish first-in first-out (FIFO) ordering of table contents, which is needed for customer applications requiring event processing.