temp tables 
Author Message
 temp tables
If I create a one field temp table with no logs and insert very few rows
(less than 15), will it always be created in buffer, or will that be a
disk entry also.


Wed, 02 Jun 2004 07:04:37 GMT
 temp tables

It depends.  You will, by happenstance, handle it in memory, however it may
go to disk eventually.  You will have a logical log entry for the creation
of the table - although not for the insertion of rows (that's what the
'without log' buys you) and the table may eventually be written to disk.

So you create the table, it's created in memory, if a checkpoint happens
along or a LRU clean operation, it will wind up on disk.  If your session
(mind you not the query) completes before the LRU or checkpoint gets to
those pages and the table is dropped, the engine may not feel the need to
actually write the pages to disk, but I wouldn't count on it.

cheers
j.

Quote:
----- Original Message -----


Sent: Friday, December 14, 2001 6:04 PM
Subject: temp tables

> If I create a one field temp table with no logs and insert very few rows
> (less than 15), will it always be created in buffer, or will that be a
> disk entry also.



Thu, 03 Jun 2004 05:53:33 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. Temp table vs Global Temp table

2. returning temp result of temp table to ADO/ASP

3. temp table problem with global temp option

4. Massive Updates: Temp Or Not Temp Tables?

5. temp table in temp dbspace

6. ALTER TABLE on temp tables, table variables

7. Error renaming table file to a temp table table caused ingres to crash

8. Temp tables Vs Table Variables

9. In-memory table vs Temp Table

10. Moving data from a temp table into several other tables

11. Temp Table vs. Table Variable

12. temp table or static table?


 
Powered by phpBB® Forum Software