Re: [sqlite] Why does the order of indexed columns matter when creating an index?

<[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

[sqlite] Why does the order of indexed columns matter when creating an index?

Hello, I've looked for an explaination in the following pages without success: http://www.sqlite.org/optoverview.html http://www.sqlite.org/cvstrac/wiki?p=QueryPlans So I hope someone can help me... CREATE TABLE node( id INTEGER PRIMARY KEY, name TEXT ); CREATE TABLE edge( orig INTEGER