The sqlite3_stmt_status() interface with the SQLITE_STMTSTATUS_FULLSCAN_STEP operator returns the number of full- table scan steps that occurred during the evaluation of a prepared statement. This information can be used by debugging logic within an application to help locate cases where new indices would improve performance.
We are proposing to change the meaning of SQLITE_STMTSTATUS_FULLSCAN_STEP slightly so that it only counts full- table scan steps for tables in queries that do not include the NOT INDEXED clause. This would technically be an incompatible change. However, we are thinking that nobody ever uses the NOT INDEXED clause (it is an SQLite extension and is not standard SQL) nor do many people use SQLITE_STMTSTATUS_FULLSCAN_STEP. And hence, we are guessing that we can make this change without breaking any legacy code. If you think otherwise, please let me know. D. Richard Hipp d...@hwaci.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users