Hi All, I have the table which has the following indexes: CREATE INDEX Zactivate ON sig (peerid,flowid,fbid); CREATE INDEX Zfbid ON sig (flowid,fbid); CREATE INDEX Zsignature ON sig (peerid,Zsignature); And below are where statements: WHERE Zsignature = ? AND peerid = ?"; WHERE peerid = ?" WHERE peerid = ?"; WHERE flowid = ? AND peerid = ?"; WHERE flowid = ? AND peerid = ?"; WHERE flowid = ? AND peerid = ?"; WHERE flowid = ? AND peerid = ?"; WHERE flowid=? AND fbid=? AND peerid=?"; WHERE peerid=? AND stale='2'"; WHERE peerid=? AND flowid=? AND stale='2'"; Should Ionly need two indexes. The second one should not be there. Now the write operation will be very slow. Any ideas? Thanks, JP
_______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users