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
rows are stored exactly the same in both Volatile and "normal" tables, only the space differs, PERM vs. SPOOL.