OBIEE query performance issue

Question

Dear all,

We have serval report of day granularity.

Because data volumn is becoming bigger, we have efficiency problem.

We tried to seeding caching query data, it seems not working.

We have all join field indexed.

Is there any other way to solve the performance issue except using aggregation table?

Thanks and Regards,

Thomas Dodds · Answer

1415129 wrote:I am trying to find some way to optimize our biee model, like joins, indexs etc by checking the SQL execution plan.Alvin

I get the feeling you are heading in a path that you will think of trying to force hint the use of indexes in the physical layer of the RPD or you have already done so ... this is NOT the way to go.  @Gianni Ceresa and @Christian Berg are spot on in their comments

[Deleted User] · Answer

1415129 wrote: Actually, we have a very wired situation, we can not rely on our DBA team.

^--- So basically your BI initiative is more or less bound to die?

1415129 wrote: I am trying to find some way to optimize our biee model, like joins, indexs etc by checking the SQL execution plan.

^--- Indexes are not "in the BIEE model". They are in the database.

"SQL execution plan" <--- mainly depends on the database. Not OBIEE.

Performance problems are not solved in a tool which is a dynamic query generator and which does not store data on its own. They are solved at the source.

Or do you want to load your whole source data into cache? .....

1415129 · Answer

@Gianni Ceresa

@Christian Berg,

Thank you all.

Actually, we have a very wired situation, we can not rely on our DBA team.

I am trying to find some way to optimize our biee model, like joins, indexs etc by checking the SQL execution plan.

Alvin