Re: number of extents

Posted in 2005

Art S. Kagel — Tue, 13 Dec 2005 18:24:29 -0500 — source: Usenet: comp.databases.informix

Bill Hamilton wrote: > This is on IDS 934 TC2. > A partial output of this query follows ... <SNIP> > Should I try to get the number of extents down on system tables? > Also, on automatic indexes, when should you worry about how many extents > they are in? > sending to informix-list Not to worry. All system catalog tables are cached in the data dictionary cache so extent fragmentation in the catalog is not a problem since about IDS 7.1. Art S. Kagel