Database Index Doesn't work for column have a value with a colon (":")
Executing the query below shows a full scan in the query explain plan
SELECT A.TASK_ID FROM LOAN_TASK_MAPPING_MODEL A WHERE A.ASSIGNEE = 'com.nucleus.user.User:9032';
But if we remove ":" from "com.nucleus.user.User: 9032", it starts using the index created on the ASSIGNEE column.
Please correct me, what am I doing wrong? My database is an oracle.
source to share