<[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
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
2 matches
Mail list logo