Indexing data from multiple tables with Oracle Text
- by Roger Ford
It's well known that Oracle Text indexes perform best when all the data to be indexed is combined into a single index.
The query
select * from mytable
where contains (title, 'dog') 0
or contains (body, 'cat') 0
will tend to perform much worse than
select * from mytable
where contains (text, 'dog WITHIN title OR cat WITHIN body')…