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

[mike9]

could you analyze the index an check if the optimzer choses then the correct index.
To analyze the indexes you could simply set cascade=true

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