Hi, it should be replaced with joins. Find more information here:
https://apacheignite-sql.readme.io/docs/performance-and-debugging#section-sql-performance-and-usability-considerations Evgenii 2017-11-19 16:34 GMT+03:00 Aurora <[email protected]>: > Ignite 2.2： > > common sql: select p.* from "personCache".Person p join > "OrganizationCache".Organization o on p.org_id = o.id > where o.area in ('london','paris','roma',...) > > > Is there the better sql from performance perspective? > > thanks. > > > > > -- > Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >
