LIKE uses an index only if the expression starts with a literal value that
at compile time. I guess SIMILAR TO could be taught to do the same, but
optimization hasn't yet been done. It's fairly restrictive because the
string has to be a fixed value and not a parameter.
> Of course, you can force an index for the table with the clause ORDER BY
> You can? Yes, you can force Firebird to retrieve rows in indexed order
some simple queries, but that's not at all the same as using an index to
a subset of a table for retrieval.
[Non-text portions of this message have been removed]