how to improve the performance of the report

system · June 17, 2008, 10:37am

Hi,

I have one report and its taking 30 secs to retreive the data. but the requiremnet is like it should take only 15 secs.

First it was taking 40 secs. After analysing the tables and indexes its taking 30 secs. but it should be 15 secs. Any idea?
I am using one Materialized View and two dimension tables for the report. MV is built on fact table.

Thanks,
Suganthi

Sugpalan (BOB member since 2008-06-02)

system · June 17, 2008, 10:47am

Hi

You just check the chances for query optimization by seeing the query generated, your DBA will help you in that front using the Execution plan.

Regards

Siva.M

looksmee (BOB member since 2006-02-08)

system · June 17, 2008, 11:23am

Please, find this Reporter FAQ entry: Why is my report so slow

Andreas (BOB member since 2002-06-20)

system · June 17, 2008, 4:04pm

have you considered index awareness?

johnwxyz (BOB member since 2008-01-26)

system · June 18, 2008, 5:25am

Also check your machine config…

Msb (BOB member since 2008-02-15)

system · June 18, 2008, 8:41am

Thanks everyone. Issue is resolved. I was using a filter in the query and that column is from Fact Table which has huge data. Now I took the same column from dim table and added it in the filter. Report is taking only 12 secs now.

Thanks,
Suganthi

Sugpalan (BOB member since 2008-06-02)