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

[pranavgovind]

Mike,

matnr is not a unique.

Here is the analyze statment.

DBMS_STATS.GATHER_TABLE_STATS ('quoteswp',p_tabname,'',estimate_percent=>10, degree=>4);

I am not analying the index. Does it matter?.

is your column "VBAP"."MATNR" unique?
did you define it as beeing unique (is the index VBAP_MATNR_IDX1 an unique index)?

which command did you execute to analyze the table?

which command did you execute to analyze the index?