Using Oracle Hints

The easiest way is to add a special object to your universe (maybe in a special class called “Hints”). This objects contains two single quotes (so BO thinks there are characters in it :lol: ) followed by the hint itself. So like this:

'' /*+RULE*/

which will cause Oracle to execute the query RULE based instead of COST based. Position the hint object as the first object in your query. It will also show up in the group by but will do no harm there :rotf: .

See also post here

HenkK


HenkK :netherlands: (BOB member since 2004-03-02)