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"
> Sent: Sa
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.
---
2 matches
Mail list logo