Taka <sqlite-T/[EMAIL PROTECTED]> wrote:
Ah, maybe I wasn't quite clear enough.
What I meant was, is there any performance difference between:
CREATE INDEX ON my_table ( a , b , c )
and
CREATE INDEX ON my_table ( c , b , a )
I'm guessing not, presumably because the index is using some kind of
hashing but I thought I'd ask, just to be sure :-)
There is no performance difference while creating an index, but the
order of columns in an index may affect the performance of subsequent
querties. Specifically, the order of columns affects whether or not an
execution plan for a particular query would use this index. After all,
you are creating an index to improve performance of your queries, not
just because you feel like it, right?
Igor Tandetnik
