Database Index Doesn't work for column have a value with a colon (":")

Question

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.

+3

user2338018 04 Aug At 13:54

1 answer

NavyPier · Answer 1 · 2015-08-12T11:06:29+0000

Have you tried to force the use of a hinted index?

I know this is not the optimal answer, but sometimes it helps.