Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL tuning with LIKE expression
My gues is that the reason is caused by implict typeconversion on the
database field.
The numeric field is converted imlisitly to string and that prevents the use
of index.
Don't use LIKE operator on numeric fields.
Received on Mon Sep 22 2003 - 14:21:56 CDT