Sybase IQ now accumulates the messages from the index advisor along with the number of times each occurred while the server has been up. The INDEX_ADVISOR_MAX_ROWS option limits the number of messages accumulated. Upon reaching the specified limit, the INDEX_ADVISOR stops storing new messages, but continues updating counts and timestamps for existing messages. The procedure sp_iqindexadvice, retrieves accumulated advice information.
See “INDEX_ADVISOR_MAX_ROWS option,” Chapter 2, “Database Options,” and “sp_iqindexadvice procedure,” Chapter 10, “System Procedures,” in the Sybase IQ Reference Manual.
