Hello! You can use EXPLAIN to see whether index was used or not. I suggest you to check your specific queries.
Regards, -- Ilya Kasnacheev вт, 2 июл. 2019 г. в 10:17, Prasad Bhalerao <[email protected]>: > 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 >
