How the data is stored in Volatile tables....

General

How the data is stored in Volatile tables....

Hi,

In case of volatile tables, If i newly create a VT table with 10K rows. How the data will store in VT. I'm aware that data will be stored in Spool space. But here every AMP will be assigned with some spool, So if i create a VT with Primary Index will there be any data distribution to the AMP's. Just like normal tables. 

Appreciate your help!

Thanks in advance

2 REPLIES
N/A

Re: How the data is stored in Volatile tables....

Hi Bharath,

rows are stored exactly the same in both Volatile and "normal" tables, only the space differs, PERM vs. SPOOL.

Re: How the data is stored in Volatile tables....

Thanks a lot for quick reply Dieter. :)