Re: search engines

From: Bruce Schreiber <bruces_at_real-info.com>
Date: 22 Feb 2002 06:46:26 -0800
Message-ID: <f1645a5c.0202220646.413d2067_at_posting.google.com>


Pablo,

Thanks for the reply.

No, I have never heard of bit indexes before now. From what I've read, they seem to make queries go faster. I'm using Informix (sorry, that's what we have). How would you implement it on Oracle if this is a peculiarity to the RDMS.

"Pablo Sanchez" <pablo_at_dev.null> wrote in message news:<tK2b8.148$FG2.395676_at_news.uswest.net>...
> "Bruce Schreiber" <bruces_at_real-info.com> wrote in message
> news:f1645a5c.0202141054.5e15b376_at_posting.google.com...
> > How can search engine search through millions of records in just a
 few
> > seconds?
>
> Like everything, there is no magic. The cost is in the loading,
> comparatively slow however the searching is maximized. I'm sure
> you've seen bit indexes and the like... Sybase IQ, Oracle's bit
> indexes, etc... you can also use inverted indexes....
Received on Fri Feb 22 2002 - 15:46:26 CET

Original text of this message