Extents
Posted in 1997
"Tony_ReynoldsAccounting & Purchasing" — — source: Informix-list mailing list archive (1991-1998)
Hi,
Im doing my first extent sizing exercise in an attempt to improve
performance.
in the sysmaster database I am using the following sql:
select dbsname,tabname,count(*) number, sum(size)
from sysextents
group by dbsname,tabname
order by number desc
Is the size the size of the extent in k - some of my figures dont
seem to add up....
Tony Reynolds, NEC Group, Birmingham , UK 8-))