having worked with databases for 20 years i can see your indexes are not fully scoped. i see this as your issue
having SUM(product_views_app) > 2 OR SUM(product_clicks_app) > 1 add those columns to the composite index so that it doesn't need to access the underlying table and can just use the index. -- Sent from: http://apache-ignite-users.70518.x6.nabble.com/
