Re: Direct-Path on Global_Temp_T ?

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 Fitzjarrell Received on Mon May 07 2007 - 15:11:34 CDT