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.