How to use "Oracle Hint Optimizer" in BO

building semantic layer
1

Hello,

I am using BO Xi 3.0, and oracle 11g. I have created uinverse based on 1 dimension and 1 fact table, trying to get data its talking long long time.
I used the Indexing but still its takes long time.

My DBA modify the query in Oracle and applied “Hint optimizer” e.g. /*+ first_rows(10) */ *.

Is there a way we can apply this oracle function in BO.

Thanks for the reply.

Kajal :us: (BOB member since 2006-09-08)

2

Hi

Create a Universe object with your hint '/*+ first_rows(10) */ ’ and use that in your report as first object. This object may not parse in Universe but it will work in report.

Thanks,Thani.

stvel (BOB member since 2007-10-04)

3

Hello Thani,

Thanks for the reply.

As I understand I need to create a object in universe and in Select on that object i need to add this '/*+ first_rows(10) */ ’ or i need to add column name instead of First_rows(10).

Thanks.

Kajal :us: (BOB member since 2006-09-08)

4

The former, rather than the latter. Its been discussed many times, try a search if you aren’t getting results. My top tip would be only use them as a last resort :wink:

Nick Daniels :uk: (BOB member since 2002-08-15)

5

Agreed :slight_smile: .

I think your DBA need to pull his finger out and look at why everything is so slow.
Have you applied functions in BO that may be killing the indexes?

Do an explain plan to see what the query is doing, you may even have problems with your BOXI server configuration?

Mak 1 :uk: (BOB member since 2005-01-06)