Is there any way to use oracle optimizer hints in SQL generated by BO to make querries work faster ? OR some simlar way which can generate faster response ?
Open the universe in designer, choose parameters. Then choose to edit the connection used and select Custom. You can fill in the hint there.
I think that BO will not show the hint at report level, but it should work equally well.... T. Blom
Information analyst
tbl@shimano-eu.com
You can use "Strategies" in Designer, look at chapter 4 of the Designer's manual. A strategy is a script that reads structural information from a database or flat file, you'll need to create an external strategy, there is a prebuilt strategy for Oracle available.
You can also add your own modification to the SQL of the object in the SQL editor in Designer.
And finally you can force use of COST or RULE optimizations by Oracle in ORA.INIT or through an object in Designer.
Hope this helps Stick to your guns
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.