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 <[email protected]>: > 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. > >
