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
All the site contents are Copyright © www.stechies.com and the content authors. All rights reserved.
All product names are trademarks of their respective companies. The site www.stechies.com is in no way affiliated with SAP AG.
Every effort is made to ensure the content integrity. Information used on this site is at your own risk.
The content on this site may not be reproduced or redistributed without the express written permission of
www.stechies.com or the content authors.