Re: Temporary Tables - 3 of 3

Agreed and the other ways of doing things without GTTs and the flexibility 
they provide by using standard SQL are ?? did you try to use 
dynamic_sampling with GTTs? it works reasonably well. We have about 800 
sessions that use multiple GTTs and aslong as you are appropriately sized, 
there is no problem.

Last I checked everyone is telling me space is cheap, so I could allocate 
more space _if needed_ 

Raj

On 8/28/05, Rajesh.Rao@xxxxxxxxxxxx <Rajesh.Rao@xxxxxxxxxxxx> wrote:
> 
> The main disadvantage with global temporary tables, is that you cannot
> gather statistics for them (unless a hint is provided), and hence, the
> optimizer might not choose an optimal plan, especially when you join GTT's
> with permanent tables in your transactions. Second, is that if you have
> too many sessions accessing the GTT, then since each session gets its own
> copy of the table, you might end up occupying too much temp space.
> 
>

Other related posts: