Hi, Thank you for pointing out the mistake. After changing the order to 1 as follows, SQL executed quickly.
public class DnsNetBiosAssetGroupData implements Data<DefaultDataAffinityKey>,UpdatableData<DefaultDataAffinityKey> { @QuerySqlField private long id; @QuerySqlField(orderedGroups = {@QuerySqlField.Group(name = "dns_nb_asset_group_data_idx1", order = 2)}) private long assetGroupId; @QuerySqlField(orderedGroups = {@QuerySqlField.Group(name = "dns_nb_asset_group_data_idx1", order = 3)}) private int assetTypeInd; private int partitionId; @QuerySqlField private long subscriptionId; @QuerySqlField private long updatedDate; //@QuerySqlField (index = true) @QuerySqlField(orderedGroups = {@QuerySqlField.Group(name = "dns_nb_asset_group_data_idx1", order = 1)}) private String value; But now with this change I cannot use the same index for condition, "wh re assetGroupId=? and assetTypeInd=?" . Do I have to create separate group index on assetGroupId and assetTypeInd ? Thanks, Prasad On Tue, Aug 21, 2018 at 9:29 PM Ilya Kasnacheev <ilya.kasnach...@gmail.com> wrote: > Hello! > > I think that value should have order of 1 to be used here. Can you try > that? > > Regards, > > -- > Ilya Kasnacheev > > 2018-08-21 18:56 GMT+03:00 Prasad Bhalerao <prasadbhalerao1...@gmail.com>: > >> Original Sql query: >> >> SELECT dnsnb.value, >> dnsnb.id >> FROM DnsNetBiosAssetGroupData dnsnb >> JOIN TABLE (value VARCHAR = ? ) temp >> ON dnsnb.value = temp.value >> WHERE dnsnb.subscriptionId = ? >> AND dnsnb.assetGroupId = ? >> AND dnsnb.assetTypeInd = ? >> >> temp table list has around 1_00_000 values. >> >> I also tried changing the indexes as follows. But it did not work. >> >> public class DnsNetBiosAssetGroupData implements >> Data<DefaultDataAffinityKey>,UpdatableData<DefaultDataAffinityKey> { >> >> @QuerySqlField >> private long id; >> @QuerySqlField(orderedGroups = {@QuerySqlField.Group(name = >> "dns_nb_asset_group_data_idx1", order = 1)}) >> private long assetGroupId; >> @QuerySqlField(orderedGroups = {@QuerySqlField.Group(name = >> "dns_nb_asset_group_data_idx1", order = 2)}) >> private int assetTypeInd; >> private int partitionId; >> @QuerySqlField >> private long subscriptionId; >> @QuerySqlField >> private long updatedDate; >> //@QuerySqlField (index = true) >> @QuerySqlField(orderedGroups = {@QuerySqlField.Group(name = >> "dns_nb_asset_group_data_idx1", order = 3)}) >> private String value; >> >> >> Thanks, >> Prasad >> >> On Tue, Aug 21, 2018 at 7:35 PM ilya.kasnacheev < >> ilya.kasnach...@gmail.com> wrote: >> >>> Hello! >>> >>> Can you please show the original query that you are running? >>> >>> Regards, >>> >>> >>> >>> -- >>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/ >>> >> >