I finally got around cleaning up my patch for Oracle which allows fast
ticket content searching.
It does two things:
- first gets rid of the pre and postpend of % around searches
(we like it better this way. If you use prepend you’ll kill any index)
- rewrites searches for ticket content by rewriting the query to use
an Oracle content index. This could be enhenced for any CLOB
column. Might do that myself or leave that to someone else.
Hope someone finds this useful,
Joop van de Wege JoopvandeWege@mococo.nl