with rowid real 8m13.442s user 7m37.536s sys 0m5.852s explain query plan select word_id from patterns_content; 0|0|0|SCAN TABLE patterns_content USING COVERING INDEX sqlite_autoindex_patterns_content_1 without rowid real 7m9.446s user 6m54.924s sys 0m4.288s explain query plan select word_id from patterns_content; 0|0|0|SCAN TABLE patterns_content USING COVERING INDEX sqlite_autoindex_patterns_content_1