Oninit cdi / Archive
Talk to an expert →

Re: selects/inserts/updates/deletes

Posted in 1998

John Carlson — — source: Informix-list mailing list archive (1991-1998)

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.