An index advisor now generates messages when the optimizer would benefit from an additional index on one or more columns in your query. For details see “INDEX_ADVISOR option” in the Sybase IQ Reference Manual.