Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 03 Feb 2005 @ 04:12:16 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Secondary Index on Volatile tables
From:   Michael Larkins

The Teradata manuals are normally accurate. SPOOL space does not support any form of secondary indices. Since volatile tables are created in SPOOL space there are no answers to your questions regarding the creating or dropping of a secondary index on a volatile table.

If you need secondary index definitions on a temporary table use a Global table which is materialized in TEMPORARY space, which does allow secondary index definitions.

Hope this helps,

Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor

  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023