DIRECT

Specifies to bypass memory (WOS) and write table data directly to disk (ROS). This hint overrides the table's load method, by default set to AUTO.

The following statements support this hint:

• DELETE: If used with /*+DIRECT*/, stores delete vectors in ROS.

• INSERT
• MERGE
• UPDATE
• CREATE [TEMPORARY] TABLE AS

For more information about data load options, see Choosing a Load Method.

Syntax

statement-name /*+ DIRECT */ ...