Re: row sizes

Posted in 1995

"Malcolm Weallans" — Tue, 10 Oct 1995 19:25:12 GMT — source: Informix-list mailing list archive (1991-1998)

> Hi All, > > > Does anyone out there know how to work out the row size > of a table from a sql table definition ? > > > > > Thanx, > > > Manoj Schroff (manoj@dspdev.dalsys.co.uk) There is a good write up for this in the OnLine Admin Guide. Basically you add together the field lengths, and then add 4. Calculating the index size is quite easy as well. Add together the length(s) of the fields in the index and add 8. Malcolm Weallans Online Database Consultancy Phone 0628-72154 Fax 0628-37463 CIX - onlinedbc