Hi, ravipesala Thank you for your proposal, merging index file is a very useful feature as we have already met serious performance issue caused by too many index files (case 1).
But I think the core problem of case 2 is too many loads which should be mainly considered in segment compaction part. As "one segment one index file" design seems more clear and simple. Regards, Jin Zhou -- Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/