What does /*+ RULE */ do?

[LeonelSanchezJr]

I have seen some direct SQL statements in Webfocus that read like this:

SQL ORA
SELECT /*+ RULE */

I was told that "rule" portion helps Webfocus return / execute the SQL Oracle query faster. Is this true?



Thanks,

Leo ;-)

 

[craigiep]

These are known as Hints, and can be used to override the dbms eg forcing oracle to use a different index