Re: Direct-Path on Global_Temp_T ?

On May 7, 2:11 pm, "fitzjarr..._at_cox.net" <fitzjarr..._at_cox.net> wrote:
> On May 7, 2:30 pm, "tea" <t..._at_mailinator.com> wrote:
>
> > 10gR2/Solaris 8
>
> > Does it make any sense/difference to do Direct-Path Insert on GTT
> > (Global_Temp_Table) ?
>
> > i.e. add "/*+ APPEND */" to
> > "INSERT into GTT SELECT * FROM sometable"
>
> > or is it moot ?
>
> > thanks
>
> No, it doesn't make sense, really. The redo generated for temporary
> tables is minimal, and can't be disabled. Thus a direct-path insert
> behaves no differently for a temporary table than does a plain-vanilla
> insert.
>

David,

I agree from the redo aspect. But:

• Are there no benefits from not needing to search for free space?
• Or from building a complete (previously empty) block in memory rather than updating an existing block?

Just curious

--
Hans Forbrich   (mailto: Fuzzy.GreyBeard_at_gmail.com)
*** Feel free to correct me when I'm wrong!
*** Top posting [replies] guarantees I won't respond.