Skip to Content
Former Member
Oct 18, 2006 at 08:33 AM

Relevance and importance of Statistics in a cube



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.