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

SQL Anywhere 12.0.1 » 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