RE: Hint for in memory temporary table?
- From: "Bobak, Mark" <Mark.Bobak@xxxxxxxxxxxxxxx>
- To: <kutrovsky.oracle@xxxxxxxxx>, <tanel.poder.003@xxxxxxx>
- Date: Fri, 13 Jan 2006 16:35:10 -0500
I'm not aware of any such hint.....but then I'm no CBO expert either.....
--
Mark J. Bobak
Senior Oracle Architect
ProQuest Information & Learning
"There are 10 types of people in the world: Those who understand binary, and
those who don't."
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Christo Kutrovsky
Sent: Friday, January 13, 2006 4:32 PM
To: tanel.poder.003@xxxxxxx
Cc: ORACLE-L
Subject: Re: Hint for in memory temporary table?
No, just something that will force my global temporary table session segment to
stay in memory, instead of going to tempfile.
On 1/13/06, Tanel Põder <tanel.poder.003@xxxxxxx> wrote:
> Are you talking about materialize hint?
>
> Tanel.
>
> ----- Original Message -----
> From: "Christo Kutrovsky" <kutrovsky.oracle@xxxxxxxxx>
> To: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>; "oracle-l"
> <oracle-l@xxxxxxxxxxxxx>
> Sent: Friday, January 13, 2006 10:58 AM
> 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?
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
Christo KutrovskySenior Database/System AdministratorThe Pythian Group
--
//www.freelists.org/webpage/oracle-l
BEGIN:VCARD
VERSION:2.1
N:Bobak;Mark
FN:Bobak, Mark
ORG:ProQuest Information and Learning;Database Group
TITLE:Software Architect, Sr-TPD
TEL;WORK;VOICE:734.975.6086
ADR;WORK:;ECC4-N01E04;1400 Eisenhower Parkway
LABEL;WORK;ENCODING=QUOTED-PRINTABLE:ECC4-N01E04=0D=0A1400 Eisenhower Parkway
EMAIL;PREF;INTERNET:Mark.Bobak@xxxxxxxxxxxxxxx
REV:20051213T223654Z
END:VCARD
Other related posts:
