Re: indexing table by word not by column

"ori" <ori_m57_at_hotmail.co.il> wrote in message news:tbck5q4cc3n7e6_at_corp.supernews.com...
> Hi there,
>
> Is there a way to index a table by word and not by column?
> for example:
> If my table have 4 colomn (each one is a var char) which all may contain
 the word I am looking
> for , the sql for such un unindex table would be something like:
>
> Select column1, column2, column3, column4 from table where (column1 like
 '%word%') or (column2
> like '%word%') or (column3 like '%word%') or (column4 like '%word%')
>
> which will take forever to run on 100,000 rows.
>
> if I could do some index like a table contain the key word and the row
 number maybe something like
> word: rows:
> abc 1,2,3,4
> def 2,3,11
>
> then this search will go much faster...
> Is there a way to create such an object?
>
> thanks
>
> ori
>
> --
> Posted via CNET Help.com
> http://www.help.com/

Oracle Intermedia has been designed to meet this need.

Hth,

Sybrand Bakker, Oracle DBA Received on Mon Mar 19 2001 - 16:40:48 CST