• Newskooler

    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.