Picking the best index for a table scan

[Michael Alexeev <mi...@gmail.com>]

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