SQL Reference Guide > SQL Reference Guide > SQL Statements > CREATE INDEX > Index Storage Structure for Ingres Tables
Was this helpful?
Index Storage Structure for Ingres Tables
By default, indexes are created with an ISAM storage structure. There are two methods to override this default:
To specify the default index storage structure for indexes created during the session, use the -n flag when issuing the command that opens the session (SQL, ISQL, or CONNECT). For more information about this flag, see the System Administrator Guide.
To override the session default when creating an index, specify the desired storage structure using the STRUCTURE option when issuing the CREATE INDEX statement.
To specify whether the index is to be compressed, use the WITH [NO]COMPRESSION clause. By default, indexes are not compressed. If with compression is specified, the STRUCTURE option must be specified. An RTREE index cannot be compressed. To change the storage structure of an index, use the MODIFY statement. For details about table storage structures, see MODIFY.
Last modified date: 11/28/2023