Re: Update Statistics

Cathy Kipp writes: |> Not to be difficult here.... ok, nevermind, I'm going to be difficult... |> |> We are about to migrate from Informix standard engine to on-line. |> |> When they said ON-LINE we assumed they meant ON-LINE. One of our big |> reasons for moving is that our users won't have to be down for backups. |> Why then would we ever want our users to have to be down for UPDATE |> STATISTICS? |> |> Under standard engine, we can UPDATE STATISTICS with all users logged on |> doing whatever they like. I just checked the source, and I do not see anywhere where we lock the table during update statistics. What we *do*, and this is true for SE as well as OnLine, is lock the system catalog entries as they are being changed (of course we would do that - it is an update after all). Has anyone actually *seen* a table lock on a table for which stats are being updated? UnLess it is a mighty BIG table, the timeframe would be pretty small regardless. Paul Friday, does this count as non-silence on the part of Informix ;-)? Dave