Re: How to Create Local Temporary Table

jackal wrote:
> Hi,
>
> But isnt that a good functionality? All these temp tables in SQL server
> are created in the tempdb database and you can place the tempdb
> datafiles in a different disk altogether. I too many times have to
> create temp tables in Oracle, to aid in reporting purposes. But those
> are temporary with respect to the other normalized ones, slightly out
> of the league.
>
> Why do the faculties advice not to create temp tables in Oracle. Please
> elaborate on this.
>
> Regards
> Jackal

Read Sybrand's comment again. They are unnecessary. They are slow in SQL Server but required due to the product's problem with locks and the transaction model.

If you don't need to be crippled ... don't ask people for advice on how to break your leg.

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