list ORACLE-L
Objet : RE: A bit of SQL tuning
Bilou,
This was discussed not so long back on the list, and I'm pretty sure the up
shot was that to search for a string with a % wildcard on either side you
need to look in to the Intermedia (Context) cartridge.
HTH
Mark
-Origin
Bilou,
This was discussed not so long back on the list, and I'm pretty sure the up
shot was that to search for a string with a % wildcard on either side you
need to look in to the Intermedia (Context) cartridge.
HTH
Mark
-Original Message-
Bilien
Sent: Thursday, June 07, 2001 08:26
To:
> I'd be interested to get an opinion on the fastest way to do an indexed
> search on a substring aka I'm looking for the "WHERE MYCOL=%ABCD%"
> functionnality. The underlying table is very huge. I can see several ways
to
> do that
I can't see any ways to do that. If there's a leading % Oracle w