>From your plan I see you have different data sets in Oracle and Ignite. activiy scan in Oracle results in 117k scans, in Ignite 120k activityuseraccountrole in Oracle results in 144k, in Ignite 1147k etc
Please run performance test on the exactly same dataset. 2016-05-31 9:27 GMT+03:00 jan.swaelens <[email protected]>: > Hi, > > Please fine the explain plan attached. > > explainplan.png > <http://apache-ignite-users.70518.x6.nabble.com/file/n5338/explainplan.png > > > > br > jan > > > > -- > View this message in context: > http://apache-ignite-users.70518.x6.nabble.com/Unexpected-performance-issue-with-SQL-query-followed-by-error-tp4726p5338.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. > -- Best regards, Alexei Scherbakov
