Re: Usage Statistics

On Fri, 11 Nov 1994, Joe Lumbley wrote: } Jack Parker (jparker@hpbs3645.boi.hp.com) wrote: } } : Pholks, } } : Can any one talk to me about this topic? How do you tell what data is used } : by who and how frequently? } } } One thing I like to do is to imbed a debugging flag in programs that } turns on "set explain on". When you run the program with the flag, the } sqlexplain.out file tells you exactly which tables get hit, how the } optimizer is using the indexes, and most importantly, how often each } SQL statement executes. Especially if the SQL is deep inside an ESQL/C } program, inside of lots and lots of loops, you can find that you are } thrashing a disk to death when you could be hitting it once by reworking } the code. } } BTW, I put in an enhancement request several years ago asking for some } sort of usage statistics, especially on indexes. Guess they ignored it. } } Joe } } -- } --------------------------------------------------------------------------- } Joe Lumbley Dallas, Texas Hi, y'all } Watch for my INFORMIX DBA Survival Guide from Prentice-Hall/Informix Press } ISBN 0-13-124314-4 (12431-3) Due in bookstores October 28, 1994 } orders: orders@prenhall.com (515) 284-6761 fax (515) 284-2607 } ---------------------------------------------------------------------------- } As has been noted before a real source of information on use is the logical logs, but there appears to be no good tool for extracting it easily in summary form. In light of Joe's comment, it should be noted that the log include insert, update, delete stuff and is not a source of information on which tables are accessed in the sense mentioned by Joe above. -- Con Woodall Colorado St. U.; Veterinary Teach. Hosp.; cwoodall@vth1.vth.colostate.edu