but sometimes, the query planner is not that smart, see:

< left is my old query > Right is the same query, but with dim = CAST(? as VARCHAR)

I was using 16 cores (4 servers), now they all sum up are only using 25% of 1 core