All Forums Database
mithunk 7 posts Joined 02/13
16 Apr 2013
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 ?
 

Mithun
mithunk 7 posts Joined 02/13
16 Apr 2013

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

Mithun

gkatiyar 19 posts Joined 09/13
30 Oct 2013

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;

Regards,
Gaurav Katiyar

You must sign in to leave a comment.