Volatile Table

Tools & Utilities
Highlighted
Enthusiast

Volatile Table

Hi,

 

When i am creating a volatile table it is taking 4+ hrs, whereas the same Select Query is returning in seconds. WHY?


Accepted Solutions
Junior Contributor

Re: Volatile Table

There's a 99.999% probability for:

You didn't specify a Primary Index, thus it defaults to a badly distributed NUPI on the 1st column with thousands/millions or row per value.

Plus your session runs in Teradata mode, thus it defaults to a SET table doing Duplicate Row Checks.

 

1 ACCEPTED SOLUTION
1 REPLY
Junior Contributor

Re: Volatile Table

There's a 99.999% probability for:

You didn't specify a Primary Index, thus it defaults to a badly distributed NUPI on the 1st column with thousands/millions or row per value.

Plus your session runs in Teradata mode, thus it defaults to a SET table doing Duplicate Row Checks.