EXPLAIN SELECT activity0._VAL , activityuseraccountrole0 ._VAL FROM "activity".ACTIVITY activity0 LEFT OUTER JOIN "activityuseraccountrole".ACTIVITYUSERACCOUNTROLE activityuseraccountrole0 ON activity0.activityId=activityuseraccountrole0.activityId;
will show query execution plan without actually executing it. Look for strings like /* "activityuseraccountrole"."Activityuseraccountrole_idx": ACTIVITYID = ACTIVITY0.ACTIVITYID */ 2016-05-27 15:48 GMT+03:00 jan.swaelens <[email protected]>: > Hello, > > Yes indeed, I am using those classes. Can I verify in the H2 console that > the indexes are there as expected? > > br > jan > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/Unexpected-performance-issue-with-SQL-query-followed-by-error-tp4726p5279.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. > -- Best regards, Alexei Scherbakov
