I have a return dataset of around 11k records on this sqlite query. Is there a scope for changes in this query that can help performance gain. Thanks
SELECT count(*) as count, easting,northing FROM tableName where site='K' AND is_deleted=0 AND easting !='' AND northing !='' AND easting !=0 AND northing !=0.
Aucun commentaire:
Enregistrer un commentaire