Re: selects/inserts/updates/deletes

so...a result like this means the maillist table was read 34965 times? meaning it had 34965 selects? and 19969 inserts, 0 updates and 17447 deletes? or is the reads if a select returns 10 rows, then the isreads are 10? tabname isreads iswrites isrewrites isdeletes maillist 34965 19969 0 17447 thanks for the reply! John Carlson wrote: > Kerry Adkins wrote: > > > > is there a way with the systables or with the onstats to show how many > > selects, inserts, > > updates, deletes have been performed against the engine? > > i'm running 7.24 on sun solaris 2.5.1. > > tia. > > You might want to look at the sysptprof table in the sysmaster > database. It can give you table-level info. > > I use it in a 4gl program to assist me with growth patterns and 'hot > tables' listings. > > John Carlson > Informix DBA > WH Smith, Inc. -- _^..^_ _^..^_ =\\ "/= =\\ "/= email - kadkins@gte.net / | | / | | / )| || / )| || _ ( __\\...) _( __\\...) \\ \\ (_) homepage - http://www.geocities.com/~kkitten