Re: Hint for in memory temporary table?

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" To: "Jonathan Lewis" ; "oracle-l"

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 Received on Fri Jan 13 2006 - 18:29:28 CST