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_at_jpmchase.com <Rajesh.Rao_at_jpmchase.com> 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.
>
>

--
http://www.freelists.org/webpage/oracle-l