Worksheet takes so much time to process the query.

Asked By jennina yale 20 points N/A Posted on - 03/08/2012

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.

• Status: Open
• Question Views: 819
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Oracle Database

Answered By Kanhai Else 0 points N/A #90563

Worksheet takes so much time to process the query.

 

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.

 

About Kanhai Else

Questions
0

Answers
56

Best Answers
8

• Vote Up 0 Vote Down

• Posted on - 03/18/2012
• Question Category: Oracle Database