As per this doc <https://apacheignite-sql.readme.io/docs/performance-and-debugging#section-sql-performance-and-usability-considerations>, if the query contains OR operator indexes may not be used as expected. As a work around the query can be rewritten using UNION ALL condition.
But if I use "USE INDEX" hint to force query optimizer to use given index, will it solve the problem with OR operator? Is it guaranteed that query optimizer will always use the index provided in "USE INDEX" hint? Thanks, Prasad
