Worksheet takes so much time to process the query.

Asked By 20 points N/A Posted on -
qa-featured

I know this is old but the system is using Oracle Business Intelligence 10g. when we click on a worksheet it takes so much time to process the query.

SHARE
Answered By 0 points N/A #90563

Worksheet takes so much time to process the query.

qa-featured

 

Oracle Business Intelligence 10g.

This a performance issue. The SQL that you have created for the entire worksheet must have to be evaluated so that it reduces the extent of aggregation at attribute and schema level.

This job requires that you change the schema and try using indexes to your strategy. Try to aggregate very less, A single output may be obtained from more that n one query. This is where the performance of the SQL matters.

One query may take very less time as it does aggregation in a different way than the other.

However you try Increasing you RAM if it does not works. Thanks.

 

Related Questions