Re: will "like" always use full table scan instead of function-based index?

From: Bib Endum <gd-newsgroups_at_spamex.com>
Date: Thu, 19 Feb 2004 13:41:05 -0500
Message-ID: <er7Zb.13010$d34.1331479@news20.bellglobal.com>

"Tom McCready" <noone_at_nowhere.com> a écrit dans le message de news:c12tti$mglk$1_at_rs7.loc.gov...
> Hello all,
>
>
> create index handle_ix2 on handles(rawtochar(handle))
>
> 1 select rawtochar(handle) from handles where
> 2* handle like chartoraw('LOC.PNP/CPH.3B21874')

Herrrr...

You have a function based index using the rawtochar() function, but in your select you use the chartoraw() function.

Correct me, but I think you need to use the same function you used to create tou index when you select your data.

Also, I don't think using the LIKE operator in this case will help you. Received on Thu Feb 19 2004 - 12:41:05 CST