Re: Temporary table use and the redo log
Date: Wed, 9 Sep 2009 07:21:45 -0700 (PDT)
Cons to this approach from the web:
http://psoug.org/reference/hints.html (search for append)
" (Append) Instructs the optimizer to use direct-path INSERT if your database is running in serial mode. Your database is in serial mode if you are not using Enterprise Edition. Conventional INSERT is the default in serial mode, and direct-path INSERT is the default in parallel mode."
http://forums.oracle.com/forums/thread.jspa?threadID=351967 (bottom of page)
reply from tkyte:
insert /*+ append / can be many times slower than insert! why? Because insert /+ APPEND / waits for the IO to complete to disk - where as insert puts a buffer into a cache and lets dbwr write it out in the background. insert /+ append */ may well be many times slower than insert in many circumstances...
Looks like a suck it and see situation Received on Wed Sep 09 2009 - 09:21:45 CDT