Skip to Content
0
Aug 25, 2017 at 03:21 PM

HANA fastest way to insert into table - direct path insert? (/*+append */ hint)

612 Views

Are there any options for quickly inserting millions of rows into a table? In Oracle the /*+ append */ hint was a method of directly inserting into a table without the overhead of transaction control features.

The data is selected from a very low latency on-premise remote MSSQL source.

  • column table - 4 million rows x 19 columns - no constraints - 2m43s
  • row table - 4 million rows x 19 columns - no constraints - 3m34s