DATE Index in Teradata

Database

DATE Index in Teradata

Hi ,

I create a volatile table as mentioned below

CREATE MULTISET VOLATILE TABLE temp_table
(
 col1   BIGINT  ,
 start_dt  DATE  
)ON COMMIT PRESERVE ROWS;

I have to first create an index on col1 then create a DATE INDEX on start_dt. How can i acheive this in teradata ?

Tags (1)
2 REPLIES

Re: DATE Index in Teradata

I saw this DATE index in sybase. In teradata should we use the PPI ?

Please clarify.

Re: DATE Index in Teradata

Hi Mithun,

Can you please provide more details about DATE index, do you need secondary index on DATE column ? In that case you can create it as below-

CREATE MULTISET VOLATILE TABLE temp_table

(

 col1   BIGINT  ,

 start_dt  DATE  

)

primary index (col1),

index (start_dt)

ON COMMIT PRESERVE ROWS;