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,