Re: Why Not Allow Temp Tables?

From: Pete Cresswell <x_at_y.z>
Date: Tue, 23 Sep 2003 01:24:52 GMT
Message-ID: <8hpsmvshfq5s9vtckp44n4bofl7o1cg3iu@4ax.com>

RE/
>The reasons are as follows:
>
>1. Kills performance and scalability
>2. The privileges to create objects do not belong in a production schema
>except during brief periods when it is being built or modified
>under the direct supervision of the DBA.
>3. Completely unncessary so no reason to do it.

I'm not trying to be difficult - I'm taking everything that's been said to heart...but I'd also like to be able to argue the point with somebody who tells me they want to use Temp tables.

#1 makes sense - but it would be good to have a little insight into why.

#2 sounds like argument by assertion - but that's probably because I don't know diddley.... Something about objects being created/destroyed impacting performance would be my first guess.

#3, I'm guessing, is because of the availablity of global temp tables. True?

---

PeteCresswell Received on Mon Sep 22 2003 - 20:24:52 CDT