Re: How to Create Local Temporary Table

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 20 Apr 2006 09:56:58 -0700
Message-ID: <1145552213.717305@yasure.drizzle.com>

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.

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.

We use arrays in Oracle for performance ... not as a workaround. 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.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Thu Apr 20 2006 - 11:56:58 CDT