Same is true for Oracle 8i/9i/10g.
E.
--- Rob Lohman [EMAIL PROTECTED] wrote:
Microsoft SQL seems to use the column names from the
first select. So that would be a, b in your example.
Rob
- Original Message -
From: [EMAIL PROTECTED]
To: Sqlite-users sqlite-users@sqlite.org
Hi.
You're joining the table with itself using 'id'. However, there's no index just
on that field. I'm not sure how exactly SQLite utilises indices, but it might
be unable to use index on (id,key,source) triple to optimise calculation of
m1.id = m2.id.
Does this sound sensible?
Cheers.
---