sqlite> explain query plan  SELECT t0.ZFEED_ID, COUNT( t0.ZID) FROM ZMESSAGE t0 WHERE  t0.ZREAD = ? GROUP BY  t0.ZFEED_ID ;
0|0|0|SEARCH TABLE ZMESSAGE AS t0 USING INDEX ZMESSAGE_ZREAD_ZFEED_ID (ZREAD=?) (~10 rows)