Informix

 View Only
Expand all | Collapse all

Update Statistics on Non index field

  • 1.  Update Statistics on Non index field

    Posted Thu December 17, 2020 10:58 PM

    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


  • 2.  RE: Update Statistics on Non index field

    IBM Champion
    Posted Fri December 18, 2020 05:40 AM

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