Showing posts with label SQL Lock Transaction Direct Insert. Show all posts
Showing posts with label SQL Lock Transaction Direct Insert. Show all posts

Friday, October 23, 2009

How to tell if "direct-load insert" was used with the APPEND hint

Both the serial and parallel version of:

   INSERT /*+ APPEND */
          INTO ...
    SELECT ...
        FROM ...

uses the same quick interface as Direct Load under some conditions. Conditions are listed in Concepts Guide.

How can one to tell if direct insert feature is used or not?