Re: Hint for in memory temporary table?

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
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


--
Christo KutrovskySenior Database/System AdministratorThe Pythian Group
--
http://www.freelists.org/webpage/oracle-l


Other related posts: