Thanks Val. On 28 December 2016 at 01:47, vkulichenko <[email protected]> wrote:
> If collocation doesn't work, you should get incorrect results unless you > enabled distributed joins (which you should not do if you're not going to > utilize them). > > Performance depends on many factors, number of entries for example. > Regardless of what you do, you will scan the portion of Product table that > satisfies the condition. Several things you can try: > - use group index with both serialnumber and status field > - move the condition to subquery > - run with more nodes and check if the query scales > > -Val > > > > -- > View this message in context: http://apache-ignite-users. > 70518.x6.nabble.com/Complex-queries-tp9626p9764.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. >
