All Forums Database
TD_Arch 35 posts Joined 07/05
20 Jun 2006
Queue Tables / SELECT AND CONSUME TOP N

Hi all,
I remember that there is the concept of Queue tables in Teradata V2R6, using which we can run a SELECT AND CONSUME TOP 1 from tablename. But i dont seem to get the syntax correct, nor am i able to get how to create a queue table. Also, any performace implications related to queue tables would be highly appreciated.

Thanks.

TD_Arch 35 posts Joined 07/05
20 Jun 2006

Just managed to get the create table syntax correct, and created the following queue table:

create table quetable2, queue
(create_timestamp timestamp(6) not null default current_timestamp(6), a int, b int)
;

However, can anyone please throw more light on the utility of queue tables, and also the limit on the data load that they can handle.

Thanks.

You must sign in to leave a comment.