Re: Estimating sizes of indexes

Posted in 1992

Will Hartung - Master Rallyeist — Thu, 12 Nov 92 10:35:07 PST — source: Informix-list mailing list archive (1991-1998)

> Jim Kunzman writes: [ stuff deleted ] > >Can this be done easily? > > For OnLine, this is covered (in the Guide to SQL Tutorial, pg 10-16) > Dave Of course, for the REALLY lazy, I've found that if you do a DBSCHEMA on a table, in the little comment section at the top it gives you both the size of the row, and the size of the index(es). The index size is the sum of all the indexes including their overhead/padding etc. If you're looking for data to estimate OnLine extents, etc. those numbers seem to follow the formula given in the Admin guide, and they sure beat the heck out of adding them up yourself. This was in 4.0/4.1 that I saw these numbers... Will (uunet!la4gen!villy)