<[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I supposed a very fast query even with many records, because COUNT( ) > might do its work on the index only.
Well, it does, but the work is still proportional to the number of records counted. The index helps to quickly filter out records that _don't_ match the condition, but you still have to look at every record that does. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
