Re: searching for a substring
You're pretty much hosed at the point where you say "substring". The only fast way to look up by a VARCHAR value is to look for an exact match or values that begin with a string. If you know what you're searching for ahead of time, you could precalculate the search result and store it in a separate column.
Subject
Views
Written By
Posted
2448
October 19, 2005 10:26AM
Re: searching for a substring
1424
October 26, 2005 05:13PM
1554
October 28, 2005 04:21AM
1487
October 31, 2005 01:42PM
1373
November 01, 2005 02:31PM
1344
November 02, 2005 07:07AM
1267
November 25, 2005 12:24AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.