Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » SQL Anywhere Server - Database Administration » Database maintenance » Troubleshooting SQL Anywhere database issues » Troubleshooting database server performance warnings


Performance warning: In database %3, table %1 AUTOINCREMENT column %2 is not indexed

This warning is reported when a permanent base table contains an AUTOINCREMENT column and there is no index on the column. The warning is generated only in cases where the maximum identity value for that column, as stored in the MAX_IDENTITY column in the ISYSTABCOL catalog table, is unknown or if it becomes invalid. This situation can occur if an existing column has been altered to be an AUTOINCREMENT column or if the global autoincrement settings for the database have changed.

 See also