Hi All, Let say I have a table with multiple indexes defined. Is there a way to force Calcite to generate multiple relational expressions for a given SQL where each expression would use a table scan with a different suitable index to select the best one available based on the query's filters, collation, etc?
If not, what would be an alternative? Thanks, Mike
