Re: Table Access

hi Marcus, u can try this : select dbsname,tabname,isreads,bufreads,pagreads from sysptprof where dbsname="eagle" order by isreads desc >From: Marcus.Wilkinson@ssa.co.uk >To: informix-list@iiug.org >Subject: Table Access >Date: Tue, 17 Aug 1999 21:25:32 +0100 > >Hi, > >I think I have asked this question before but can't find the answer in my >archives. > >How can I find out which tables within a database/server instance are >accessed the most. I think it was a systable??????? > >Thanks for your help. > >Marcus Wilkinson > > ________________________________ > >The information contained in this electronic mail message is confidential. >It is intended solely for the use of the individual or entity to whom it is >addressed and others authorised to receive it. If the reader of this >message is not the intended recipient, you are hereby notified that any >use, copying, dissemination or disclosure of this information is strictly >prohibited. > ________________________________ > > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com