* Brannon King <[EMAIL PROTECTED]> [2006-05-26 21:35]: > I would think this would be a valuable optimization for Sqlite > to perform automatically. When it finds an OR operation, it > should look to see if duplicating the query and using the UNION > ALL compounder would allow it to use additional indexes and if > so then duplicate it.
But it can’t: using `UNION ALL` will return duplicates whereas using `OR` won’t, so you can’t substitute the former for the latter. Regards, -- Aristotle Pagaltzis // <http://plasmasturm.org/>
