Re: How to Create Local Temporary Table

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Thu, 20 Apr 2006 15:39:03 -0400
Message-ID: <4aq6atFt63lbU1@individual.net>

DA Morgan wrote:
> Serge Rielau wrote:

>> sybrandb wrote:
>>> In Oracle you don't NEED temporary tables.
>>> You should UNLEARN EVERYTHING you learned in sqlserver or your
>>> applications will SUCK.
>>> You should also read the first two chapters of Tom Kyte's latest book,
>>> in order to understand why you are bound to fail as you stick to
>>> sqlserver habits.
>>>
>> Aren't the various collection objects (e.g. associative array (i hope 
>> I got that right) and varray of rowtype) matching local temp tables?
>> Are these considered bad features to use?
>>
>> Cheers
>> Serge

>
> Completely different concept and technology.
Definitely outside of your tolerance, agreed.
>
> Temp tables in the products that originated with Ingres (Informix,
> Sybase, SQL Server) are used as a workaround for problems related
> to locking (lock escalation) and the transaction model.
Is that so? I thought temp tables are often used to avoid redoing expensive queries perhaps. But that's just the crazy person in me....

> We use arrays in Oracle for performance ... not as a workaround.
And obviously arrays are the only concept that can do what it does because it's what you know.

> Now that Microsoft has attempted to clone the Oracle MVCC model I
> expect we will begin to see the use of temp tables disappear. Albeit
> slowly since Microsoft customers generally don't read docs.
I doubt it.

Cheers
Serge

-- 
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Received on Thu Apr 20 2006 - 14:39:03 CDT