Index %Util in dbanalys

lee_shelton

New Member
In the dbanalys output index section, there's a column on the right (SCO Unix Progress 8.2c) that's labeled "% UTIL" and another labeled "FACTOR". I thought these report the usage rates of the indexes listed.

I just created a new database with a couple of word indexes on a table. I have _not_ even written any programs that use "contains" on the table.

I ran dbanalys on it and it shows over 67% on each of the two word indexes. Other indexes that I know I haven't used or used very little have similar UTIL numbers.

Is this not the 'usage' for the index?

Maybe the data load and record creation process 'used' the indexes. That's probably it...

Thanks
Lee
 
Top