Re: INDEX possible for reverse wildcards?

"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