Re: How calculate number of extents of a table

try this, select tabname, count(*) num_extents, sum(size) total_size from sysmaster:sysextents group by tabname order by num_extents desc Frank On 11/22/06, Diego Morales <dmorales@districenter.es> wrote: > > Hi to all. > > > > After 3 years working fine the performance of Informix is not fine. I want > to check the query to calculate the number of extents for every table of the > database and I don't find it on cdi archive. Can anyone post me this query, > please. > > > > TIA. > > > > DJMoralesM > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list > > >