mercredi 13 janvier 2016

enhancing a select sqlite query for performance

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