#users-public - Question: if I have a column o

Channels

Newskooler
1 month ago
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. ? : )
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?
Is it correct that there is
```
capacity
```
and
```
index capacity
```
?
(sorry - many questions). I think the documentation on this end can be improved generally.

View count: 2