FW: What tables the database access most frequently

FW: What tables the database access most frequently

Post by Dirk Moolma » Sun, 31 Dec 1899 09:00:00



With IDS2000 -

database sysmaster;
select *
from sysptprof
order by (isreads / iswrites / isrewrites / ......) desc    ......your
choice

In this table you get the database name (dbsname) with the table name.  You
can play around with this.

Dirk

-----Original Message-----


Sent: Wednesday, December 06, 2000 2:20 PM

Subject: What tables the database access most frequently

Hi,
   I want to know in Informix , what tables the database access most
frequently, what indexes access less/most frequently. Does someone already
has the SQLs or script to check this ?

Thanks