DBA suspected corrupt index, so he dropped the index (on field1 in the example).  We reran the query with the "group by" ("select field1, count(1) from bad_table group by field1") and...