I create a volatile table as mentioned below
CREATE MULTISET VOLATILE TABLE temp_table
col1 BIGINT ,
)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 ?
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-