WebIntelligence 6.5.1 Report Query Question...

system · December 18, 2007, 7:51pm

Greetings,

We have a SQL query that performs elegantly when using an optimizer hint (/*+ rule */) when running it within TOAD against an Oracle database. Unfortunately, we are not aware of a way to use this optimizer hint within WebIntelligence. Has anyone done this? If so, can you help us? Basically, we want to incorporate Oracle optimizer hints within our report queries to “optimize” their execution.

Thanks in advance!

delberthickman (BOB member since 2007-12-18)

system · December 19, 2007, 2:15am

Try taking a look at this topic on hints objects from the Semantic Layer / Universe Designer forum.

Anita Craig (BOB member since 2002-06-17)

system · December 19, 2007, 8:47pm

Thank you Anita. That was exactly what I needed!

Regards,
Delbert

delberthickman (BOB member since 2007-12-18)