Hello Lucky. Please try setting enforceJoinOrder parameter on connection to true, retrying the request with various order of tables joined to see if it helps. It might turn out that one order of joins performs much better than the other one.
Setting the parameter is documented here: https://ignite.apache.org/releases/latest/javadoc/org/apache/ignite/IgniteJdbcThinDriver.html Regards, -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
