Re: INDEX possible for reverse wildcards?

From: Mikito Harakiri <mikharakiri_at_iahu.com>
Date: Fri, 4 Jun 2004 17:48:00 -0700
Message-ID: <aW8wc.38$924.259_at_news.oracle.com>


<ctcgag_at_hotmail.com> wrote in message news:20040604191153.742$ex_at_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?)

Trigger happy posting, sorry. The answer was in the second part of your original message. Received on Sat Jun 05 2004 - 02:48:00 CEST

Original text of this message