low index distinct keys

[gandolf989]

drop the index?

I'm curious, how would this lower the logical io's?

If it were me I would use range partitioning based on date.
Then purging data would involve dropping partitions.