New feature in dostats
Posted in 2016
Folks: Announcing the June 27, 2016 release of my utils2_ak package. There is a new feature not present in the April release: - Dostats has a new option, --small-tables-high that processes smaller tables using a single UPDATE STATISTICS HIGH command for all columns. For many smaller tables this can be a bit faster than the usual multiple LOW, MEDIUM, and HIGH command suite and produces better distributions. There is also a new option --small-tables-threshold=<num> to specify the maximum number of rows a table can contain and be considered a "small" table. The default is to only process empty tables this way if --small-tables-high is specified. You can also set the AUS threshold for small tables and enable that using the existing --AUS-THRESHOLDS option setting the AUS_SMALL_TABLES threshold record. Currently you can only download the latest utils2_ak from my web site at www.askdbmgt.com/my-utilities until the IIUG completes the upgrade of the IIUG web site. Art Art S. Kagel, President and Principal Consultant ASK Database Management www.askdbmgt.com Blog: http://informix-myview.blogspot.com/ Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. --94eb2c05665c4246fc053662b50d