Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 03 Feb 2005 @ 18:25:05 GMT

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

Subj:   Re: Secondary Index on Volatile tables
From:   Dennis Calkins

On Wed, 2 Feb 2005 15:20:01 -0500, Anomy Anom wrote:

  I have been told that one could not create indexes on volatile tables  


This is from the Developer....

------------------ Include message ----------

Secondary indexes are allowed to be specified on a volatile table when it is created.

They are not allowed to be added/dropped via CREATE/DROP INDEX syntax.

Statistics are not allowed to be collected on volatile table. I believe the Parser uses all-amp sampling to build the stats internally when necessary.

-------------------- end message ---------------

I think the intent here is that When the Volatile table is materialized within the session, the Table header can not be modified it is just inhereted from the original Create Table statement.

Therefore if the Original Create had the INDEXES that is fine.

You just can't add Additional or Drop indexes after you materalize the table within your session context.

  <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: 28 Jun 2020