In order to meet the challenges of the exponential growth of information and the demand for real-time access to data, Sybase IQ has significantly enhanced the performance of loading High_Group (HG) indexes and Containment (also called WORD) (WD) indexes, while transactions are still allowed to access the tables being loaded. This load performance improvement for HG and WD indexes affects:
INSERT...SELECT
INSERT...LOCATION
LOAD
UPDATE
CREATE INDEX
Updatable cursors
The LOAD TABLE statement now performs parallel loads of HG and WD indexes, thus executing faster than in previous releases.
