Re: extents of tables

Posted in 1998

deeky@my-dejanews.com — Tue, 27 Oct 1998 12:33:10 GMT — source: Informix-list mailing list archive (1991-1998)

In article <909423669snz@kontron.demon.co.uk>, andy@kontron.demon.co.uk wrote: > The 'sysmaster' database has a 'sysextents' pseudo-table that has this > information. > > > From an Informix newbie: > > > > Can someone tell me how to get a report of the number of extents per table > > (not just system tables but data as well)? I know about onstat -t but this > > output seems kinda cryptic... > > > > I am running 7.24.UC5-1 > > > > TIA Thanks Andy.... But what information in this table tells me that I may be in need of a reorg? Is it the size field... for example if a table says it has a size of 10 does that mean 10 extents? > > -----------== Posted via Deja News, The Discussion Network ==---------- > > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own > > > > -- > Andy Lennard andy@kontron.demon.co.uk > > -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own