hi Venu and Ajantha, For the new SI solution, I have some suggestions also. 1. agree to avoid query plan rewrite 2. push down the SI filter to the pruning step of the main table directly on the driver side, but we need a distributed job to improve performance 3. segment level usability for example, when only one segment doesn't have indexes, but other 99 segments have indexes, SI should be used to improve the filter query of the index column. 4. consider the filter column's selectivity, it should impact the priority of the indexes (include main index). phase 1: base on rules(filter order or hint) phase 2: base on cost (statistics)
----- Best Regards David Cai -- Sent from: http://apache-carbondata-dev-mailing-list-archive.1130556.n5.nabble.com/