What tables have extents?

-- tabextents.sql

select dbsname,

tabname,

count(*) num_of_extents,

sum( pe_size ) total_size

from systabnames, sysptnext

where partnum = pe_partnum

group by 1, 2

order by 3 desc, 4 desc;

Previous slide

Next slide

Back to first slide

View graphic version