Re: extents of tables

Just something to add: Any table that is set up with any kind of fragmentation will not show up with this query because that tables partnum will be 0 which will not be found in the sysmaster:sysptnhdr table. Frank Testa Columbia House In article <363ED735.8741B5F9@jonners.cix.co.uk>, Jon Myatt <jon@jonners.cix.co.uk> wrote: > Try this bit of SQL: > > select a.tabname, > trunc(b.nptotal*4096/1048576,2) as size_MB, > hex(a.partnum) as partnum, > b.nextns as extents, > trunc(b.npused / b.nptotal * 100,0) as perc_used > from systables a, sysmaster:sysptnhdr b > where a.partnum = b.partnum and a.tabid > 99 > order by 4 desc> > HTH > > Jon. > > > 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