FW: What tables the database access most frequently

With IDS2000 - database sysmaster; select * from sysptprof order by (isreads / iswrites / isrewrites / ......) desc ......yourchoice In this table you get the database name (dbsname) with the table name. You can play around with this. Dirk -----Original Message----- From: owner-informix-list@iiug.iiug.org [mailto:owner-informix-list@iiug.iiug.org]On Behalf Of LuckeLuke Sent: Wednesday, December 06, 2000 2:20 PM To: informix-list@iiug.org 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