I looked through the Oracle Optimizer Hints documentation but couldn't locate a specific reference for a —+rule. This rule appears to be an out-of-date remnant from a code generating tool that was intended to replace "—+rule" with user or produced /*+ SQL */ hint code.
What are your thoughts? Does the —+rule code in the above example [literally] do anything? or should I just throw it away?
Oracle 10g2 with the most recent supported upgrades, Delphi 6 with Direct Oracle Access components. The majority of the Legacy SQL code was written for Oracle 7 and 8.
My query:
SELECT --+rule
userid,
username
FROM
users
ORDER BY
userid