|
|
|
Supreme Being
Group: Forum Members
Last Login: 7/24/2008 8:31:03 AM
Posts: 109,
Visits: 22
|
|
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.
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 7/24/2008 8:31:03 AM
Posts: 109,
Visits: 22
|
|
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.
|
|
|
|