Post reply

Is there the equivalent of NOLOGGING & APPEND ?

  • May 13, 2002 at 8:59 am

    #104849

    In Oracle you can specify at a table level whether to write to the redo log for a insert/delete/update by marking the table as NOLOGGING and using the APPEND hint. Unfortunately BCP isn't an option. Does equivalent functionality exist in MS SQL?

    Many thanks

    Steve Taylor

  • May 13, 2002 at 4:39 pm

    #429062

    Not sure if I understand what you are needing to do or what Oracle does with those keywords exactly. But since BCP is not an option have you looked at BULK INSERT statement?

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

  • May 13, 2002 at 6:57 pm

    #429070

    quote:

    Not sure if I understand what you are needing to do or what Oracle does with those keywords exactly.

    Nologging disables redo log entries for initial creation and bulk loads

    -Reduces disk I/O

    -Eliminates serial writes to redo log files

    -No entries for Direct Path inserts or APPEND inserts

    -Can be specified at partition and LOB level

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply