Performance: Use of JOIN to speed up SELECT on MARC Z-field !?

Hi forum,

I have an performance issue here. A Z-append field is to be selected from the MARC records. One entry is needed per material (MATNR).

Since the Z-append field is nowhere near an index or the key, I thought to use a join with another database table (z-table), which holds all possible MATNRS and where MATNR is a key field.

The sizes are roughly 150 million MARC entries and about 100,000 entries in the Z-table.

What would be the wise thing to do here !?

Thanks for any advice,

Chris