19 Nov
2014
19 Nov
'14
8:11 a.m.
On Wed, Nov 19, 2014 at 6:00 AM, Ernest Zaslavsky < ernest.zaslavsky@sizmek.com> wrote:
[...] it may happen in production – you will have 5-15 strings across 1M of objects.
Just be aware that for low cardinality of distinct values in many rows, and a non-unique index, you can have much better performance for some access patterns with ordered indices compared to hashed ones. We had such an issue, easily fixed by going to an ordered index. FWIW. --DD