1916221 - Table scan performed when comparing a numeric value to a string uniquely indexed column

Query plan for SELECT on a table with an indexed varchar column performs a table scan when comparing to a number.

SAP Sybase SQL Anywhere (all version, all supported platforms)

SAP SQL Anywhere all versions

slow, performance problem, varchars, long time , KBA , BC-SYB-SQA , SQL Anywhere (on premise, on demand) , Problem

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Visit SAP Support Portal's SAP Notes and KBA Search.