Hi, EXPLAIN should show all the indexes. Are you sure that these indexes can be used for your query? You also can use USE INDEX hint to force the use of the index.
Best Regards, Evgenii вт, 11 авг. 2020 г. в 16:22, Axel Luft <[email protected]>: > EXPLIN PLAN doesn't show any indexes used although I created them. We are > using python3 (sql interface). The aggregation query on 1.000.000 rows is > very slow with about 4seconds. > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
