Hi team general question around indexes:
• Is it a rule of thumb that bloom filter should only be enabled for cols that are
part of the primary key in general but not otherwise? since it helps to prune segments as much as possible?
• Can a col have both BF and inverted index at the same time b/c BF just prunes segments while inverted helps to pick the matched rows? Or it is not suggested since inverted can already find all the matched rows in constant time so bloom is wasted?
• One requirement for disabling forward index is to
enable inverted and dictionary encoding. Do they have less storage consumption than having default forward index enabled? trying to understand the tradeoff here.