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

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

For details, see Choosing a Load Method in the Administrator's Guide.

Syntax

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

Examples

The following CREATE statement's AS clause contains the load method hint /*+DIRECT*/, which specifies to load the data queried from test_table1 into ROS:

=> SELECT * FROM test_table1;
 col1 | col2 | col3
------+------+------
    4 |    5 |    6
    1 |    2 |    3
(2 rows) 
=> CREATE TABLE test_table2 DIRECT AS SELECT /*+DIRECT*/ * FROM test_table1;
CREATE TABLE 
=> SELECT EXPORT_TABLES ('','bar');
                         EXPORT_TABLES 
-------------------------------------------------------------------------------------
 CREATE TABLE public.test_table2 
   ( 
     col1 int, 
     col2 int, 
     col3 int ) 
   DIRECT ;
 (1 row)