HELP IN XPS

Posted in 1997

bala peddi — Fri, 17 Oct 1997 11:49:59 -0400 — source: Informix-list mailing list archive (1991-1998)

We Have XPS 8.11 with 32 nodes. I am trying to find space by user/database using following Query. database sysmaster; SELECT systabnames.dbsname, count(distinct systabnames.tabname), sum(sysptnext.pe_size) FROM systabnames, sysptnext WHERE systabnames.partnum = sysptnext.pe_partnum and systabnames.dbsname in ( select name from sysdbspartn) GROUP BY 1 ORDER BY 3 DESC; Question is ? 1. Is this the right way to do it or not? Because it takes more time (between 1 to 2 minuts depending on PDQ) is there a way to reduce the time? 2. system table Sysptnext is not documented in XPS manuals.If INFORMIX change this table in next version my Query will have no meening. Thanks in advance BALA PEDDI Cunsultent Boston Email : bala.peddi@fmr.com