Re: Hint for in memory temporary table?

From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 13 Jan 2006 17:29:28 -0000


There is a cache_temp_table() hint, but
I haven't done any experiments on it.


Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html
Cost Based Oracle: Fundamentals

http://www.jlcomp.demon.co.uk/appearances.html
Public Appearances - schedule updated 10th Jan 2006

----- Original Message ----- From: "Christo Kutrovsky" <kutrovsky.oracle@xxxxxxxxx> To: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>; "oracle-l" <oracle-l@xxxxxxxxxxxxx> Sent: Friday, January 13, 2006 4:58 PM Subject: Hint for in memory temporary table?


Hello,

Do you guys remember what was the hidden/special hint to create a
global temporary table in memory or to force the data to stay in
memory?


--
Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group
--
http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

Re: Hint for in memory temporary table?
From: Christo Kutrovsky

References:
- Hint for in memory temporary table?
  - From: Christo Kutrovsky

Re: Hint for in memory temporary table?

Other related posts: