Sybase IQ now allows the use of NULL in data values on a user created unique multicolumn HG index, if the column definition allows for NULL values and a constraint (primary key or unique) is not being enforced. For more details, see “Multicolumn indexes” in the “Notes” section of the CREATE INDEX statement in Chapter 6, “SQL Statements” in the Sybase IQ Reference Manual.
