Finding All the Red M&Ms: A Story of Indexes and Full-Table Scans