ALTER INDEX command restriction [CR 375585]

The ALTER INDEX command returns an “index not found” error if you try to alter an index in a local temporary table. If you try to alter an index that is automatically created, such as a default index, IQ returns a “cannot alter index” error.

Only indexes in base tables or global temporary tables with owner type USER can be altered.

This information was omitted from Chapters 5 and 6 of the Sybase IQ System Administration Guide, from Chapter 6 or the Sybase IQ Reference Manual, and from Chapters 3 through 6 of the Sybase IQ Troubleshooting and Error Messages Guide.