Why all fields in all tables? Why not a few fields in a table? (Basically
you are asking Oracle to search all fields in all tables via a full table
scan - ouch) Google certainly doesn't search all fields in all tables.
Also %string% is not searching just by word but by parts of a word. What
you want to look into is intermedia - then you don't have to specify the
%string% and it is morelike a google search.
Jim
"Steven" <steveNnO_at_SgPeAoMdan.nl> wrote in message
news:3d2e94c0.4616337_at_news.workbenelux.nl...
> Hi,
>
> Someone thought it would be a nice idea to implement a search 'a la
> google', searching (more or less) all fields in all tables, probably
> with like '%string%'.
>
> Does anyone have any ideas how to implement this efficiently. Or
> perhaps arguments why we shouldn't do this?
>
> Can a column be indexed in such a way that it's used by "like
> '%string%'" (don't think so...)
>
> Can Oracle Text be used for this, or is that more useful for searching
> (external) documents?
>
>
> Btw, we're using Oracle 9i.
>
> Thanks,
>
> Steven
Received on Fri Jul 12 2002 - 09:40:32 CDT
