RE: analyze_idx utility

Wow, somebody actually downloaded that old thing? I wrote it years ago. There's a fairly complete help file that goes with it - but then it probably doesn't explain how to compile it. There is a makefile that comes with do a make i4gl_ver - if you are using honest to goodness compiled 4gl or make r4gl_ver - is you are using RDS. It is a utility which gives you a SHOULD BE view of your indices - not an actual. In other words it will scan your source code, look at your catalogues, even read your data to determine a 'index factor' or somesuch - in other words a score for what SHOULD be indices. Useful if you have no control or view over the model. You have to manually tell it to do all three of those things - since you may not want it to do one or more of them. It was written under 5.0 - before sysmasters came about, it had no way of figuring out what indices are actually used. In other words it is a sledgehammer, not a scalpel. The score is based on: how many times the column (perferably table.column) occurs in a where clause in the code. src_cnt degree of uniqueness for the column - this is gated by a page threshold - if the table is larger than the configurable threshhold, it won't try to scan it, otherwise it will read each column for uniqueness. Number of potential joins to other tables within the db. One of the cute things about the program is that it reads the catalogues and shows you on the screen what each index is made up of. Let me know how you get on with it. If you find it halfway worth while, I might even re-visit it with an eye towards bringing it into the current age. cheers j. > -----Original Message----- > From: Tony Woods [mailto:twoods786@hotmail.com] > Sent: Wednesday, January 17, 2001 3:55 PM > To: informix-list@iiug.org > Subject: analyze_idx utility > > > Hello friends, > > Has anybody used the analyze_idx utility which gives a report > on the Index > usage(used/not used/highly used)? Does this utility gives the > reliable > report? Can anybody please give me the steps to use the > utility? I am having > a hard time to configure and use it. > > Thanks in advance for all your replies. > _________________________________________________________________ > Get your FREE download of MSN Explorer at http://explorer.msn.com >