Title
#users-public
Newskooler

Newskooler

07/06/2022, 12:25 PM
Question: if I have a column of type
symbol
which I know will only ever have two distinct values - what’s the optimal way to set it up in regards to various settings such as: • capacity • distinctValueEstimate • nocache / cache • index • etc. ? : )
12:30 PM
My understanding is that: • distinctValueEstimate is the number that follows
capacity
. For example
capacity 128
means that: 128 is the distinctValueEstimate and that it’s expected to have 128 distinct values. • cache is good to be used for below 100k unique symbols nocache above 100k unique symbols •
index
I don’t quite understand what it does and how it works. Is the above correct?
12:33 PM
Is it correct that there is
capacity
and
index capacity
?
12:34 PM
(sorry - many questions). I think the documentation on this end can be improved generally.