If the new column will be included in join conditions or query filters then yes, it should have at least MEDIUM level data distributions. If not, you can get away with UPDATE STATISTICS LOW for that column.
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
------------------------------
Original Message:
Sent: Thu December 17, 2020 10:58 PM
From: AMIT PATEL
Subject: Update Statistics on Non index field
Dears,
Please let me know if I add new field in table with NON INDEX field , so Do I need to run Update Statistics?
Thanks
Amit
------------------------------
AMIT PATEL
------------------------------
#Informix