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

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 ------------------------------