Patent ID: 9665612
Date: 2017-05-30
CPC Classifications: G06F

Claim:
1. A method comprising: initiating execution of a database command, the database command associated with a base table with at least one row to copy to a target table, the database command associated with a non-bulk insert mode; detecting a run-time statistic including a number of row buffers filled with rows from the base table; making a run-time decision to automatically convert the insert mode from the non-bulk insert mode to a BULK insert mode based on the number of row buffers filled with rows during execution of the database command; inserting a set of rows into the target table using the BULK insert mode based on the run-time decision; determining at least one more rows remains in one or more buffers; and inserting the one or more rows in a non-bulk insert mode and updating one or more indexes corresponding to the one or more rows in a serial mode.