Skip to Content
0
Former Member
Jun 13, 2008 at 09:23 AM

Criteria for building Aggregates

22 Views

Hi Friends

I need to build aggregates on the top 10 worst performing queries according to this criteria..

1. No. of navigation .

2. DB Time > OLAP Time.

3. Ratio of selected records from DB to transferred Records.

I have found out already 10 queries.

But I need to know that whether these queries are already using these aggregates or aggregate are already built for these queries.

Could you please tell me the procedure how to proceed furthur.

Thanks