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: How to Create Local Temporary Table

Re: How to Create Local Temporary Table

From: <jackal_on_work_at_yahoo.com>
Date: 21 Apr 2006 00:21:57 -0700
Message-ID: <1145604117.865713.229450@g10g2000cwb.googlegroups.com> 





Hi,



>If I understood you correctly, temp tables in SQL Server live only in

>memory. If that is correct, then this is a big difference between the

>two RDBMS's.




I would like to disagree on this point. Temp tables in SQL Server are
stored in tempdb database, the datafiles of which are stored in disk.
So there's no point in saying that temp tables are always in memory in
caes of SQL Server.



Regards


Jackal
Received on Fri Apr 21 2006 - 02:21:57 CDT












Original text of this message













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