How important are "hints" in a SQL query when optimizing the query?
687585May 29 2013 — edited May 30 2013I'm tuning an application (Documentum) and the query has hints. See the query below as an example....very simple example to show the point; real queries are a page of more long with multiple joins.
While tuning the query (possibly adding new indexes), how important is it to tune the query WITH HINTS, or can I drop the hints from the tuning process? This is the FORCE_ORDER hint.
select /*+ ORDERED */ object_name from dm_sysobject_s;