How does the field order in indexes work with joins?
So for example given the query:
select
t1.a,
t1.b,
t2.c
from
table1 t1 inner join table2 t2 on
(t1.id1 = t2.id2)
where
t1.a = 'abc'
would the index need to be
(a, id1)
or
(id1, a)
Does the field order in the tables have anything to do with th
> Index columns can only be used from left to right, with no skips,
> to satisfy the conditions of the query.
Ah, yes, I forgot about that one. So, I will need some more indexes.
RBS
-Original Message-
From: Igor Tandetnik [mailto:[EMAIL PROTECTED]
Sent: 04 August 2007 15:49
To: SQLite
2 matches
Mail list logo