Details
Description
Currently we can have a case where a query with facets can be answered by an index which can resolve all the constraints but don't have facets configured. At times this index might even win the cost war even if there could be an alternative index which might report to be more expensive but can answer the facets.
While it's not a good practice to have competing indexes, but index selection could have been smarter anyway.