Re: Oracle Text Search Across Multiple Columns and Different Tables

Bellas wrote:
> Hi,
>
> I'm working on a general site seach which needs to search up to about
> 20 unrelated tables. I've managed to get a basic version of this
> working using Oracle Text (10g) with a materialized view, but I'm not
> sure how this will perform when the table sizes grow (say in the region
> of 100s of 1000s of records). Do anyone know if performance will be an
> issue using a materialized view for Oracle Text search? Is it efficient
> to use a materialized view to concatenate the data from, say, around 20
> tables?
>
> However in my case the tables are unrelated. For example I have a Film
> table with name and description, classification etc columns and a Jobs
> table with job title, job description, qualification required etc.
>

If they are unrelated then how do you combine them in your materialized view? Regardless, I think that if your MV is fast-refreshable (that is, it
doesn't have to be fully rebuilt when data is added or changed in the base tables,) then Text index on it should work just fine.

regards,

    Vladimir M. Zakharychev
    N-Networks, makers of Dynamic PSP(tm)     http://www.dynamicpsp.com Received on Wed Jun 21 2006 - 10:38:08 CDT