Re: Surrogate Keys and Ignite

[Evgenii Zhuravlev <e....@gmail.com>]

Hi,

How do you want to access it? Do you want to use SQL or Key-Value API? If
KV API, then, you can't use indexes there and solution with additional
table should work for you. Also, from performance standpoint, it should be
a little bit faster than SQL joins.

Best Regards,
Evgenii

вт, 31 мар. 2020 г. в 03:06, narges saleh <sn...@gmail.com>:

> Hi All,
>  I also have a general question. Is it a good idea to have a surrogate key
> table in ignite? I want to avoid joins, and I don't want to use secondary
> indexes.  I want to look up this surrogate key table (which should be very
> small in terms of volume and is replicated across all the nodes), to find a
> dependent key that can be used to quickly to search in a cache? Is having a
> secondary index and/or doing a join quicker?
>
> thanks.
>
>