query is running very slow if the index hint is not forced

[mike9]

Is the matnr column defined in the table as a numeric or a character data type?

based on the ouptut of the explain plan it seems to be a character data type.