Tuning SAP BW query performance

[Former Member]

Dear experts,

I have a question regarding as the performance of a BW query.

It takes 10 minutes to display about 23 thousands lines.

This query read the data from an ODS object.

According to the "where" clause in the "select" statement monitored via Oracle session when the query was running, I created an index for this ODS object.

After rerunning the query, I found that the index had been taken by Oracle in reading this table (estimated cost is reduced to 2 from about 3000).

However, it takes the same time as before.

Is there any other reason or other factors that I should consider in tuning the performance of this query?K

Thanks in advance

[Former Member · Accepted solution]

check out tuning documents at []