Skip to Content
author's profile photo Former Member
Former Member

Relevance and importance of Statistics in a cube

Hi,

we are in support phase of a project.

As is the usual scenario in data loading, we had indexes deleted before running a infopackage in the relevant cube and post loading, create indexes, refresh statistics.

But as on now, the time being take to refresh statistics has increased to a considerable level, wheer we cannot afford that time. To give an idea about this the increase in time is from 10 mins to 60 mins.

As I understand about the statistics role, they are to get the information about the performance of the queries over that cube, viz DB response, query run time and so on.

Can we drop the process of statistics refresh? If so then what all can be the impacts of the same?

Thanking you in advance.

Regards

Naveen.A

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Oct 18, 2006 at 08:36 AM

    Hi Naveen,

    With a huge amount of data you can reduce % of Statistic calculation and also run this job only one time per week, and not for every upload.

    Statistics are very important in particular at first steps and uploads, but it is not necessary to run the same forevery upload.

    Ciao.

    Riccardo.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Oct 18, 2006 at 08:56 AM

    Naveen,

    Statistics uses a sample amount of data for maintaining data , you could set this to a lower limit .

    On dropping statistics .. you lose some query performance monitoring information and data loading tuning information , but then if your queries are already tuned and data loads are fine , you could drop them ... also the statistics tables get very huge , thereby causing some time to refresh the same , archive your statistics and delete old statistics which have been archived for faster performance.

    Arun

    Assign points if useful

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.