Re: UPDATE STATISTICS

Posted in 2003

alexeis — Fri, 22 Aug 2003 13:12:56 -0400 — source: Usenet: comp.databases.informix

Hi, everybody, If any column included into 'update statistics low' list has an index on it then server makes full index scan. This scan: 1. Makes b-tree cleaning of pages, that were not cleaned before last server shutdown (btree cleaner keeps its list in memory, and, when the server stops, this list is simply disappears) 1. Calculates index statistics This is why 'update statistics low' sometimes runs so slowly -- Posted via http://dbforums.com