Skip to Content
0
Former Member
May 04, 2006 at 10:07 AM

Refreshing/Updating Statistics to ODS Active table

19 Views

Hi Friends,

I have one data load issue. When i am loding data using Data mart load is running for a long time and the work process constently reading the active data table and doing nothing. When i see the active data table the volume is hige.. hence delaying the load update.. finally failing with timeout.. I think i can resolve this issue by updating/refreshing the statistics of the active table.. Can any one help me how to do update/refresh statistics for the ods.

Thanks in advance.

Regards,

Srikrishna.