hi,
I have a field (low cardinality enumeration), I know will be used in almost all queries as a filter. Usual pick is as a keyword of course.
But then the query cache is not used. keyword are supposed to be so fast they don't use the cache. But are they as fast as some other type using the cache?
So is it safe to say a keyword will be as fast as another type (short, integer), that would cache 'term' queries? Or if we know filtering will be used most of the time it's better to pick a numeric field, so it's cached?
thanks!