I thought the limit 100 would help here, but it turns out that for a column on a huge table (e.g. 20m rows) which has no dates in at all that glob has to scan through every value of the column every time, just to figure out that there are NOT 100 matches!