Re: [sqlite] Is it possible to optimize this query on a very large datatabase table

Frank Chang wrote: > So, why is my query just working accidently? I take it back - the behavior of your query is well-defined, for the simple reason that FieldName is unique, so every group only has a single row in it (as someone else has kindly pointed out - I

Re: [sqlite] Is it possible to optimize this query on a very large datatabase table

Igor Tandetnik, Here is a comparison of my query plan with your query plan on the latest version of sqlite. sqlite> explain query plan select FieldName, min(rowid) from BlobLastNameTest group by FieldName; 0|0|0|SCAN TABLE BlobLastNameTest USING COVERING INDEX claramary (~100 rows)