Hello all,
I could note find an information on that subject so far: Is there a way that
SIMILAR TO uses an index? I did not see it so far:
select * from bau2org where ORGANISATIONSEINHEIT SIMILAR TO '01%' - Does not
select * from bau2org where ORGANISATIONSEINHEIT LIKE '01%' - uses
In my tests, SIMILAR TO never uses an index.
Of course, you can force an index for the table with the clause ORDER BY
Greetings.
Walter.
On Fri, May 10, 2013 at 8:55 AM, Parzival parzival1...@gmx.at wrote:
**
Hello all,
I could note find an information on that subject so far: Is there
On Fri, May 10, 2013 at 10:54 AM, W O sistemas2000profesio...@gmail.comwrote:
In my tests, SIMILAR TO never uses an index.
LIKE uses an index only if the expression starts with a literal value that
is known
at compile time. I guess SIMILAR TO could be taught to do the same, but
that
Yes Ann, you are right, but I said: an index for the table, not for a
subset of a table for retrieval.
Greetings.
Walter.
On Fri, May 10, 2013 at 11:34 AM, Ann Harrison aharri...@ibphoenix.comwrote:
**
On Fri, May 10, 2013 at 10:54 AM, W O sistemas2000profesio...@gmail.com
wrote:
On Fri, May 10, 2013 at 12:18 PM, W O sistemas2000profesio...@gmail.comwrote:
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
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 aharri...@ibphoenix.comwrote:
**
On Fri, May 10, 2013 at 12:18 PM, W O