Staffan Tylen wrote:
> SEARCH USING COVERING INDEX
> SEARCH USING INDEX
> SCAN USING COVERING INDEX
>
> What is the difference and what do they imply?

Full table scans, index lookups (searches), and covering indices are
explained on this page: <http://www.sqlite.org/queryplanner.html>.


Regards,
Clemens
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to