Re: Highest table being accessed

This is a multi-part message in MIME format. --------------EAE30CD7C2AF2AA6CF290D0A Content-Type: text/plain; charset=us-ascii Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Content-Transfer-Encoding: 7bit Susan Elliott (ISG) wrote: > Does any one know how to work out which tables in a database are being > > accessed the most ??? > > Please advise.... > Thanks in advance > Suze. (This works Informix DS only) database sysmaster; select tabname, bufreads, pagreads, bufwrites, pagwrites from sysptprof where dbsname = "nameOfDatabase" order by bufreads desc; Set the order by clause to the type of load (read or write) that you want to messure. You should notice that sysptprof only contains data for tables in use. That is when the last user accessing a table disconnects, the profile information for that table is removed. So you must do your messures 'online'. best regards claus --------------EAE30CD7C2AF2AA6CF290D0A Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Claus Samuelsen Content-Disposition: attachment; filename="vcard.vcf" begin: vcard fn: Claus Samuelsen n: Samuelsen;Claus org: Sysdeco Danmark A/S adr: Gydevang 22 B;;;DK-3450 Aller'd;;;Denmark email;internet: csa@sysdeco.dk title: Systems Manager tel;work: +45 4814 3000 tel;fax: +45 4814 3011 x-mozilla-cpt: ;0 x-mozilla-html: FALSE end: vcard --------------EAE30CD7C2AF2AA6CF290D0A--