Re: indexing table by word not by column

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Wed, 28 Mar 2001 17:59:18 +0100
Message-ID: <3ac35cd1$0$12245$cc9e4d1f@news.dial.pipex.com>

As sybrand replied to you 2 hours after your original question look into intermedia.

If however you find that you really do need to do contains searches on random columns look into your application design.

Finally if your application specifiers are forcing you to do unindexed free text searches on any columns look into the cost of an AK47.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
"ori" <ori_m57_at_hotmail.co.il> wrote in message
news:tc40s1kmgmheeb_at_corp.supernews.com...


> Well if It would be indexed by word it wont need any 'like'

>

> the  index tabled of table named AAA would contain something like

> word: row:

> abc  1,2,3

> def  2,3,9,4

>

> which mean that row 9 looks something like: "bla bla def bla" (word def in

 line 9 in AAA)


> and row 2 would be: "booo def bla bla abc" (words abc and def in row 2 in

 AAA)


>

> then searching on table AAA would only be

>

> select abc from index_table where word="abc"

>

> is there something like that?

>

>

> --

> Posted via CNET Help.com

> http://www.help.com/

Received on Wed Mar 28 2001 - 10:59:18 CST