What is a best way to detect that query does full table scan? Considering this (from http://www.sqlite.org/eqp.html ):
"Warning: The data returned by the EXPLAIN QUERY PLAN command is intended for interactive debugging only. It may change dramatically between SQLite releases. Applications should not depend on the results of an EXPLAIN QUERY PLAN command." Is it enough (and reliable) to search detail column of EXPLAIN QUERY PLAN for "SCAN TABLE%" and (if found) presume that query does full scan? The problem. We have a very large table with a lot of quering. So we came along with 4 complex covering indices and want to prohibit queries that does not supply enough values to avoid full scanning. -- Regards, SqliteDog support team _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users