Database Reference
In-Depth Information
Once you've done this you'll have a chance to review what data is actually going to
be used before you actually build the aggregations.
On the last step of the wizard you have the choice of either creating a new
aggregation design or merging the aggregations that have just been created with
an existing aggregation design. We recommend the latter. What you've just done
is optimize queries that ran slowly on an existing aggregation design, and if you
abandon the aggregations you've already got, it's possible that queries which
previously had been quick would be slow afterwards.
This exercise should be repeated at regular intervals throughout the cube's lifetime
to ensure that you built any new aggregations that are necessary as the queries
that your users run change. Query logging can, however, have an impact on query
performance so it's not a good idea to leave logging running all the time.
Search WWH ::
Custom Search