Re: Why Not Allow Temp Tables?

"(Pete Cresswell)" <x_at_y.z> wrote in message news:r5csmvgt5hrpns8ctf71jocq4jsf7jtcgr_at_4ax.com...
> We've got some performance issues that somebody thinks could be alleviated
by
> using Temp tables.
>
> However, the DB management group has decreed that no temp tables will be
used at
> their installation.
>
> I'm guessing they have a pretty good reason, but what would it be?
>
> Memory?
> -----------------------
> PeteCresswell

Use scientific method to show that they are correct or not. Your hypothesis is that using temp tables will increase performance and scalability. If the DB management group has the time they should show a small test case proving that the aforementioned hypothesis is wrong. (temp tables will cause scalability and performance problems) Tom Kyte has a nice book out that has some tools that he uses (scripts) to test such hypotheses. Tom shows how to set up small benchmarks to do these type of tests. You can go to asktom.oracle.com and search for temp tables.

Personally, I think you are going to find that the person who wants temp tables probably is from a non-Oracle background (eg Sybase or SQLServer) where they are used all the time for a variety of reasons. In Oracle it would be very very rare that a temp table would get what you are asking for. A view probably would work much better or at worst global temporary tables. Jim Received on Mon Sep 22 2003 - 21:07:12 CDT