Please update me if anybody have any script to check the status of gather stats of a table/schema in percentage (%).
Kindly share your valuable views as soon as possible. This is very urgent.
Thanks in advance.
I am aware of a script called COE_STATS.sql which generates a dynamic script called COE_FIX_STATS.sql which has a list of tables which require statistics to be refreshed. We can check this script before gathering the stats to get an idea of the number of tables requiring stats refresh. Following this post.
Will it give the already running status of Gather Stats in % that how much it completes.
Sign up for STechies