Embed Hint in a sql query

[Mobs]

Is it possible to embed HINTS ina BRIO query
If yes can someone let me know how i can do this??
Thanxs

 

[cherrya]

the answer is available on the Brio websight

http://support.brio.com/

register as a user and read

Passing Hints to the Database Optimizer (Ref.#:000503-0002)

after the select statement put /* hint */

SELECT /*+ <HINT> <HINT> other comments */
COL1, COL2 FROM TABLE WHERE

 

[largepizza]

The only problem with first suggestion is that you don't have ful control over the select stmt text generated. What you need is to add a computed item as the first field on the request line. I call the field Hint for documentation purposes.

The definition of the item should be, e.g.
/*+ Ordered */1

You need to include the 1 at the end. It will generate a column that has a value of 1, which you can hide, but it also comes in handy sometimes when counting things. Oracle will recognize the Hint text and include it in the query. You can confirm this by looking at the Custom SQL.