Re: sizes

Quick and dirty .......ahum also have a look at sysmaster:sysextents, you can join this against systables, sysindexes. or..... dbaccess sysmaster <<! -- avoid GRMBLL 999 not implemented... database <yourdb>; select * from sysindexes into temp tessie with no log;-- avoid GRMBLL 999 not implemented... database sysmaster ; select sum(size) sizeix , dbsname from sysextents where dbsname ='<yourdb>' and tabname in (select idxname from tessie); select sum(size) sizedb , dbsname from sysextents group by dbsname ; ! Superboer. Warning be carfull if you have a huge # of tables. eq a baan install tomcaml@yahoo.com schreef: > hello, > > anyone have a way or script to spit out 2 separate reports - one that > sums up total index size and the other that is total data size for a > database? > > > thanks, > tom

Thank you!