Oracle Text Search Across Multiple Columns and Different Tables

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?

Is that any other methods that can be used to index multiple columns on multiple tables? I've seen an example where multiple related tables are joined and indexed using a stored procedure here: (http://groups.google.co.uk/group/comp.databases.oracle.server/browse_thread/thread/17dd4ddcf30936b3/f6e6d73b417397d8?lnk=st&q=oracle+text+search+multiple+tables&rnum=1&hl=en#f6e6d73b417397d8)

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.

Thanks Received on Wed Jun 21 2006 - 09:20:16 CDT