How calculate number of extents of a table

Posted in 2006

Topics: Performance & Tuning, Storage & Space Management

Diego Morales — Wed, 22 Nov 2006 16:55:53 +0100 — source: Usenet: comp.databases.informix

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

↪ replying to Diego Morales

Neil Truby — Wed, 22 Nov 2006 16:15:02 -0000 — source: Usenet: comp.databases.informix

"Diego Morales" <dmorales@districenter.es> wrote in message news:mailman.342.1164210536.29126.informix-list@iiug.org... 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. I use some SQL written by Lester Knutsen. Obviously I substituted my name in the comments first. I thought it was in the IIUG archive but maybe not. I bought one of his books and it had a companion CD with loads of good stuff.