Optimizing Delete Operations

Sybase IQ chooses the best algorithm to process delete operations on columns with HG and WD indexes.

• HG Delete Operations
  Sybase IQ chooses one of three algorithms to process delete operations on columns with an HG (High_Group) index.
• WD Delete Operations
  Sybase IQ chooses one of three algorithms to process delete operations on columns with a WD (Word) index.
• TEXT Delete Operations
  Sybase IQ chooses one of two algorithms to process delete operations on columns with a TEXT index.