Does anyone have any idea about adding Optimizer hints in Discoverer???
I've added an optimizer hint (ALL_ROWS) to one of the Folders in the properties dialog box, but when I run the report and check the SQL Inspector, it does not show me that hint.
Also, the report takes the same time it used to take before, whereas it should be fast enough after adding this hint, as I've tested it by running the query.
How can I implement this.
Anyone please guide me.
