Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How to do a keyword search of a column without doing a table scan?
The context option is most likely your best bet. We did something similar with a web application and just dumped that column (and it's corresponding primary key) into a shared segment in memory and did an in-memory search and then hit the database again. Not the most preferred approach, but you have to do what you have to do.
Geoffrey Bray
Tandy Corporation
In article <35FB4ACA.7454FF7C_at_exesolutions.com>,
exe_at_exesolutions.com wrote:
> > I have a table that consist of a title column and I would like to do a
> > keyword search. For example,
> >
> > select ID, Title from Books where Title like '%Database%'
> >
> > However, the search will do a table scan without using the index on the
> > Title column.
> >
> > One way to overcome this problem is to split all the words in the title
> > column, put all the words in keywords table, index the words column and link
> > to the primary key in the Book table. However, the keywords table will be
> > very large and I need to generate the keywords table again if I make changes
> > to the Books table.
> >
> > How do I solve this problem? How do I do a keyword search without having to
> > do a table scan?
>
> Have you looked at the Context cartridge that Oracle distributes with version
> 8.x?
>
> Daniel A. Morgan
>
>
-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Mon Sep 14 1998 - 00:00:00 CDT