There are performance optimizations for joins on “integer” data types which internally are any structured types that fit in 8 bytes or less, including int, bigint, date, datetime, etc., but not including strings. So joining on bigint will be faster than joining on binary(16) by a lot in some cases.
1 Like