CREATE INDEX ix_binary_releaseID_relpart ON binaries (releaseID, relpart); 
CREATE INDEX ix_parts_binary_partnum ON parts (binaryID, partnumber);
CREATE INDEX ix_releases_searchname_postdate ON releases (searchname, postdate);