Hi, Could you help me understand the impact on data ingestion rates, when multiple secondary indexes have been created for a table/bucket? (Data inserts and updates). Especially in a scenario where there is large number of inserts and updates. Let’s say the index is on attribute A and when the value of attribute A gets updated - then there will be index maintenance for which I presume the system needs to read the base table (assuming it’s not cached in memory, for this situation). Does it not add overhead?
(Even if there is Multi dimension scaling, and indexes can be on separate nodes from data - when the index value is updated - to maintain the index, you still need to consult the base table?)
Hence the question is - What is the impact due to secondary indexes, on data ingestion rates? in scenarios where the indexed values are updated as well as part of the operational application.