Scalable updates on distribution columns of tables with indices

Details

Detail name Value
Changelog Number 537
Type Improvement
Status Resolved
Fix Versions Exasol 6.1.0
Resolution Date 2018-06-05

In former versions, updates on distribution columns triggered an all-index rebuild of the table. Even single row updates could become quite expensive.

Improvement
Updates on distribution columns are handled by copying (delete marking) and redistributing of updated rows. Indices are updated through index inserts.

Large amounts of updated rows still trigger index rebuilds as this is faster than large updates on indices. Delete marking of update rows may trigger a delete reorganization with index rebuilds when table delete margin is reached (25% deleted marked rows).