you should be able to set up automated stats collection via viewpoint. there's no need to run anything else, especially a cursor. row by row cursors force TD into single threaded processing, laying waste to the idea of an MPP
as VandeBergB mention you might switch to TD14.10's AutoStats feature.
If you still want to collect using your own logic, I would suggest switching to the apporach I described over here: How to simplify your statistics collection with a queue table
This works well and you can easily collect stats in parallel. You can simply use your existing cursor and insert the rows into the queue in that order.
Thanks VandeBergB ,Dieter for the suggestions.While I will explore the auto stats collection portlet in view point, as an immediate resolution I am planning to adopt SP (queue table approach)as suggested .
Thank you guys for the help!!
If suppose one of my table is loading a million data on daily basis by truncate load method, then how will the stats collect play its role over here for performance improvent while loading?