Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: INDEX possible for reverse wildcards?

Re: INDEX possible for reverse wildcards?

From: <ctcgag_at_hotmail.com>
Date: 04 Jun 2004 23:11:53 GMT
Message-ID: <20040604191153.742$ex@newsreader.com>


"Mikito Harakiri" <mikharakiri_at_iahu.com> wrote:
> <ctcgag_at_hotmail.com> wrote in message
> news:20040604183510.277$gk_at_newsreader.com...
> > Well, you would only need to look at index entries that start with 'w',
> > '%', or '_'. And if the first character is a 'w' or a '_', you only
> > need to look at ones where the second is 'w', '%', or '_'.
>
> And if the first character happens to be '%', then?

Then you check the rest of it to see if it matches. (What did you expect?)

Xho

>
> > And so on. Kind of
> > like a skip scan. (or course, in the example given, this wouldn't gain
> you
> > anything, as they all either start with 'w' or a wild-card.)

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB
Received on Fri Jun 04 2004 - 18:11:53 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US