Re: an SQL question

John Allen writes: |> Troy Burns - Trinity (troyb@genesis.admin.bethel.edu) wrote: |> : 2. the number of extents that table uses? |> You can back into the number of extents used from the pages allocated |> (as above) and the columns fextsize (first extent size) and nextsize |> (all subsequent extent size), also in the systables catalog. This is not a reliable way of doing this, as if a newly-allocated extent is adjacent to an existing extent for a table, the new space is simply added to the existing one, making a single larger extent rather than two smaller ones. So, if you try dividing fextsize and nextsize into the number of pages, you make or may not get the correct result for number of extents. Dave Disclaimer: The opinions expressed in this message are not those of Informix Software, its partners or lackeys. Anyone who says otherwise is itching for a fight. **************************************************************************** "I look back with some satisfaction on what an idiot I was when I was 25, but when I do that, I'm assuming I'm no longer an idiot." - Andy Rooney