Subject Re: [firebird-support] Does SIMILAR TO use an index?
Author W O
Ok Ann, I understand now your point of view.

Thank you very much for your answer.

Greetings.

Walter.

P.D: I really loves the way you write and it is not a joke.





On Fri, May 10, 2013 at 1:58 PM, Ann Harrison <aharrison@...>wrote:

> **
>
>
> On Fri, May 10, 2013 at 12:18 PM, W O <sistemas2000profesional@...
> >wrote:
>
>
> > Yes Ann, you are right, but I said: "an index for the table", not for a
> > subset of a table for retrieval.
> >
>
> Sorry to say, you've hit one of my hot buttons. When you're reading a text
> book, do you
> go to the index, read the first entry from there, go back to the index,
> find and read the
> next entry, and so on through the text? Probably not.
>
> An index is a pointer to specific information in a table, not a guide to
> all entries.
> For the latter, reading in natural order is easier and faster. The only
> time when
> bouncing between index and data is desirable is when you want only the
> first
> bit of a list of rows that is sorted in the same order as the index.
>
>
> Good luck,
>
> Ann
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]