Detecting Full Table Scans With SQLite
Summary
The article demonstrates detecting full-table scans in SQLite using prepared-statement statistics instead of EXPLAIN. It includes a Ruby example and suggests integrating a development/test warning in Rails to catch performance issues early, with notes on production decisions.