Hi,
Composite index field order matters. Try to set order=3 for "value" column.
On Tue, Aug 21, 2018 at 10:43 PM Ilya Kasnacheev
wrote:
> Hello!
>
> Yes, I am afraid that you will need another index.
>
> Regards,
>
> --
> Ilya Kasnacheev
>
> 2018-08-21 19:55 GMT+03:00 Prasad Bhalerao :
>
>> Hi,
Hello!
Yes, I am afraid that you will need another index.
Regards,
--
Ilya Kasnacheev
2018-08-21 19:55 GMT+03:00 Prasad Bhalerao :
> Hi,
>
> Thank you for pointing out the mistake.
> After changing the order to 1 as follows, SQL executed quickly.
>
> public class DnsNetBiosAssetGroupData impl
Hi,
Thank you for pointing out the mistake.
After changing the order to 1 as follows, SQL executed quickly.
public class DnsNetBiosAssetGroupData implements
Data,UpdatableData {
@QuerySqlField
private long id;
@QuerySqlField(orderedGroups = {@QuerySqlField.Group(name =
"dns_nb_asset_group_
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 :
> Original Sql query:
>
> SELECT dnsnb.value,
> dnsnb.id
> FROM DnsNetBiosAssetGroupData dnsnb
> JOIN TABLE (value VARCHAR = ? ) temp
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 val
Hello!
Can you please show the original query that you are running?
Regards,
--
Sent from: http://apache-ignite-users.70518.x6.nabble.com/
Hi,
Following SQL is taking too long to execute. It seems that highlighted
condition is not using indexes.
I have created the indexes as follows. What should be done to makes use of
index created on value column/property?
Can someone please advise?
public class DnsNetBiosAssetGroupData implement
