Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL tuning with LIKE expression

Re: SQL tuning with LIKE expression

From: Jarmo Blomster <jarmo.blomster_at_mbnet.fi>
Date: Mon, 22 Sep 2003 22:21:56 +0300
Message-ID: <bkni4m$a6p$1@news1.songnet.fi>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US