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

In article <A9qX5.9417$7.348176@quark.idirect.com>, "LuckeLuke" <nguyenq@supernet.ca> wrote: > 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 > > I am not sure exactly what you want. If I have a 10 GB table and do 20 sequential scans of it, and I have a 5 GB table and I do 20 index looks ups on it, which was accessed more frequently? DATABASE sysmaster; select * from sysptprof; See if any of the info you are interested in is in that table. I think TBLSPACE_STATS has to be on for this info to be populated. Hope this helps, Will Sent via Deja.com http://www.deja.com/ Before you buy.