Jonathan, I've tried all variants i can think off cache_temp_table() insert /*+ cache_temp_table() */ into gtt_tst t select * from other; I tried: cache_temp_table cache_temp_table(t) cache_temp_table(gtt_tst) cache_temp_table() None of which had any effect and the table was fully written in temp. Christo On 1/13/06, Jonathan Lewis <jonathan@xxxxxxxxxxxxxxxxxx> wrote: > > 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 > -- > //www.freelists.org/webpage/oracle-l > > > > -- > //www.freelists.org/webpage/oracle-l > > > -- Christo KutrovskySenior Database/System AdministratorThe Pythian Group -- //www.freelists.org/webpage/oracle-l