Interactive SQL Index Creation

If you do not specify an index-type, Sybase IQ creates an HG index.

Several front-end tools create an HG index automatically for this reason.

• Index Creation Examples
  The following two examples demonstrate Index Creation functionality.
• Status Messages for Index Loading
  By default, after every 100,000 records are inserted and loaded into indexes, you receive a progress message.
• How to Execute Groups of CREATE INDEX Statements
  Use the keywords BEGIN PARALLEL IQ and END PARALLEL IQ to delimit any number of CREATE INDEX statements that you want to execute as a group at the same time.