Re: How calculate number of extents of a table

try: select dbsname, tabname, sum(size) total_size, min(size) min_exent, max(size) max_extent, count(*) num_extents from sysmaster:sysextents group by dbsname, tabname order by num_extents desc; ----- Original Message ----- From: Diego Morales To: informix-list@iiug.org Sent: Wednesday, November 22, 2006 9:55 AM Subject: How calculate number of extents of a table 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