I am trying to understand the low cardinality reasoning and how the read gets executed. I have following questions, hoping i can explain my question well :)
1. When a write request is received, it is written to the base CF and secondary index to secondary (hidden) CF. If this right, will the secondary index be written local the node or will it follow RP/OPP to write to nodes.
2. When a coordinator receives a read request with say predicate x=y where column x is the secondary index, how does the coordinator query relevant node(s)? How does it avoid sending it to all nodes if it is locally indexed?
If there is any article/blog that can help understand this better, please let me know.
Thanks again in advance.