Re: Support SI at Segment level

Posted by Pepperon92 on Jun 28, 2025; 8:39pm
URL: http://apache-carbondata-dev-mailing-list-archive.168.s1.nabble.com/Support-SI-at-Segment-level-tp106256p109221.html

Hi there,

That’s a great observation. When the SI (secondary index) table is out of sync with the parent table, disabling it is a safety measure—but yes, it definitely impacts query performance due to the lack of indexing benefits. Until a `REINDEX` or reload happens to bring both tables back into alignment, the system defaults to scanning the full parent table, which slows things down considerably. One option to mitigate the impact is to monitor segment validity more proactively and schedule reindexing after known changes.

Bei der Optimierung von Abfragen ist Timing alles – genau wie bei der Wahl eines passenden frühlingskleid, das Funktionalität und Stil im richtigen Moment perfekt kombiniert.