Translation table sharing

A system comprising:

• at least one processor;
• at least one memory including program code which when executed by the at least one processor causes operations comprising:
• detecting, in a query execution, a join of a first table and a second table;
• and
• in response to the detecting the join, optimizing the query execution by at least scanning a plurality of first value identifiers from the first table,
• translating the plurality of first value identifiers into a value identifiers domain of the second table to form a shared translation table,
• building a hash table using the translated plurality of first value identifiers,
• performing a table scan semi-join on a plurality of second value second identifier of the second table by scanning a plurality of second value identifiers that have been filtered by the translated plurality of first value identifiers and reading one or more filtered second value identifiers of the second table,
• providing the one or more filtered second value identifiers of the second table as a probe into the hash table including the translated plurality of first value identifiers, and
• outputting one or more matching rows corresponding to matching value identifiers for matching values in the first table and the second table.

A non-transitory computer-readable storage medium including program code which when executed by at least one processor causes operations comprising:

• detecting, in a query execution, a join of a first table and a second table;
• and
• in response to the detecting the join, optimizing the query execution by at least scanning a plurality of first value identifiers from the first table,
• translating the plurality of first value identifiers into a value identifiers domain of the second table to form a shared translation table,
• building a hash table using the translated plurality of first value identifiers,
• performing a table scan semi-join on a plurality of second value second identifier of the second table by scanning a plurality of second value identifiers that have been filtered by the translated plurality of first value identifiers and reading one or more filtered second value identifiers of the second table,
• providing the one or more filtered second value identifiers of the second table as a probe into the hash table including the translated plurality of first value identifiers, and
• outputting one or more matching rows corresponding to matching value identifiers for matching values in the first table and the second table.