Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Temporary tables, performance advantages?

Re: Temporary tables, performance advantages?

From: Jim Kennedy <kennedy-family_at_home.com>
Date: Tue, 20 Nov 2001 02:21:59 GMT
Message-ID: <b7jK7.47444$XJ4.28405684@news1.sttln1.wa.home.com> 





If you have to use a temporary table then yes.  It is already created and so
it cuts down on the ddl to keep creating and dropping.  If you don't need
one then don't make the situation require one.
Jim


"Reidel Jogie" <reidel_at_cj60568-a.alex1.va.home.com> wrote in message
news:Z5iK7.38695$Ze5.20979282_at_news1.rdc1.md.home.com...


> Are there any performance advantages to be had by using GLOBAL TEMPORARY

> tables?

Received on Mon Nov 19 2001 - 20:21:59 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US