Re: serial and sequential scan

Posted in 2005

Roy Mercer — 17 Feb 2005 12:54:06 -0800 — source: Usenet: comp.databases.informix

Art, I think you mean "UPDATE STATISTICS MEDIUM FOR TABLE tabname DISTRIBUTIONS ONLY; I ran a test on 9.40.FC5 for the stores_demo database and found the MEDIUM for both table and database level did update the systables, sysindexes and syscolums. It does only get a sample of the data but you do not have to follow up with a low or high to update the system tables. Have you seen different behavior? If so what version? Thanks Roy

↪ replying to Roy Mercer

Art S. Kagel — Thu, 17 Feb 2005 17:36:52 -0500 — source: Usenet: comp.databases.informix

Roy Mercer wrote: > Art, > I think you mean "UPDATE STATISTICS MEDIUM FOR TABLE tabname > DISTRIBUTIONS ONLY; Yeah, don't know what I was smoking that night. 8-( Art S. Kagel > I ran a test on 9.40.FC5 for the stores_demo database and found the > MEDIUM for both table and database level did update the systables, > sysindexes and syscolums. It does only get a sample of the data but > you do not have to follow up with a low or high to update the system > tables. > > Have you seen different behavior? If so what version? > > Thanks > > Roy >

Glossary

UPDATE STATISTICS