A new stored procedure, sp_iqindexadvice, displays stored index advice messages and optionally clears advice storage. For example, sp_iqindexadvice lets users query aggregated index advisor messages using SQL. Information can be used to help decide which indexes or schema changes will affect the most queries. For details, see “sp_iqindexadvice procedure” in the Sybase IQ Reference Manual.
