Precisely herodt, the NOLOGGING in the SELECT as you proved is basically an alias. The table you are inserting into needs to be defined as NOLOGGING when in ARCHIVELOG mode in order to reap the benefits of reduced logging.
Printable View
Precisely herodt, the NOLOGGING in the SELECT as you proved is basically an alias. The table you are inserting into needs to be defined as NOLOGGING when in ARCHIVELOG mode in order to reap the benefits of reduced logging.
David, Okay. So we can not bypass the index log for all DML that affects the index, even direct path insert. I understand now.
Quote:
Originally Posted by slimdave