Thanks Maksim !
On Thu, Jun 23, 2022 at 11:01 AM Maksim Timonin
wrote:
> Hi,
>
> > 1. Department object has an id and affinity key on the name(it
> doesn't make sense in the real world). Does ignite create an index for
> affinity keys as well ? I don't see the affinity key index in the list
>
Hi,
> 1. Department object has an id and affinity key on the name(it
doesn't make sense in the real world). Does ignite create an index for
affinity keys as well ? I don't see the affinity key index in the list
below.
You need to configure affinity key with annotations a little bit
differently,
Thanks for the reply. I have another question on the affinity key index(if
any). When we enable sql on ignite, it by default creates an index on the
primary key(highlighted in red below). We have created a custom index on
deptId(highlighted in red).
1. Department object has an id and affinity key
SELECT * FROM SYS.INDEXES
> 22 июня 2022 г., в 18:38, Surinder Mehra написал(а):
>
> Hi,
> We have defined indexes on sql enabled ignite cache and are able to see
> indexes being used while querying.
> sqline !indexes also shows those indexes in output. But we cant see default
> index created
Hi,
We have defined indexes on sql enabled ignite cache and are able to see
indexes being used while querying.
sqline *!indexes* also shows those indexes in output. But we cant see
default index created by ignite on *primary key *and *affinity key*.
We would like to use index on key and affinity