> Using standard Oracle, you have the same limitation - I expect you
> would have the same limitation with any dbms. If you think about it,
> if you have a value which starts with a wildcard (e.g. %somestring%),
> where in the index would you start and where would you stop - you
> can't determine this, so most dbms will just default to a full table
> scan and ignore the index (unles there is perhaps another column which
> is indexed and does not have a leading wildcard).
Right - the solution being if the dbms had support for indexing
substrings, which I have been doing manually.
Received on Mon Jan 20 2003 - 13:54:09 CST
