The most performant way to load data from an external table that will also guarantee direct path loading is:

Question

Options

• AUsing Create Table as Select (CTAS)
• BUsing Data Pump
• CUsing Insert as Select (IAS)
• DUsing transparent gateways

• A
  77% (41)
• B
  2% (1)
• C
  8% (4)
• D
  13% (7)

Explanation

CTAS refers to a CREATE TABLE AS statement - a new table is created and populated with row from a specified query. The most common uses of CTAS are in these scenarios: * Creating a table identical to another table in structure, but with a filter criteria applied to its data. * Creating a table with small structural differences from an existing For best performance use Direct Path Load. The conventional path uses standard insert statements whereas the direct path loader loads directly into the Oracle data files and creates blocks in Oracle database block format. During direct-path INSERT operations, the database appends the inserted data after existing data in the table. Data is written directly into datafiles, bypassing the buffer cache. Free space in the existing data is not reused, and referential integrity constraints are ignored. These procedures combined can enhance performance.

No community discussion yet for this question.