Cases where full scans are better than indexes
On the flip side, a missing index can bring down production.<p>We experienced that just a couple of weeks ago, where a missing index and an unexpected 1000x increase in volume at a customer brought the DB to its knees. Sure it was still serving queries but at such a low rate it was effectively useless.<p>For queries that will be run more than once, I try make sure there&#x27;s an index it can use for something fairly unique.