Does the length of join key in parent/child can effect the speed of queries?

Elastic Stack Elasticsearch
1

We are on elasticsearch 6, we are using parent/child joins and it is currently based on ids which are (like '7C9F1FBF-0ACF-473D-A8CE-343968E981F6'), wondering if the length of these id or changing them to number (like '1','2981') would have any impact on performance? Thank you

2

The join is not performed on values themselves but on their ordinal, so the length of the join key shouldn't have a significant impact.

3

Thanks for the answer Adrien. Though it is interesting to see the amount of space it consumes is reduced by 3 times if I change the key from guid like string to integer! Which made me think is this if impact speed.

4

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.