<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Why does the order of indexed columns matter when creating an index?
When you create, say, a dictionary, you sort words by first letter, then by second letter, and so on. You can then quickly look up a word that begins with a given prefix. However, this sort order doesn't help you at all to find all words whose second letter is 'a', or that end in '-tion'. Database index works the same way. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users