Olivier_Desmars
Member
When doing a
proutil dbname -C dbanalys
I get the following informations about the 'INDEX BLOCK' :
INDEX BLOCK SUMMARY FOR AREA "Schema Area" : 6
-------------------------------------------------------
Table Index Fields Levels Blocks Size % Util Factor
1) Does the '% Util' column really indicate the use of the index ? Does it mean that each time a query is made on a table, this index is used ?
2) If it's a pourcentage , what is it related to ? e.g. What does mean 100% or 0% ?
3) Lastly, what's the meaning of the last column (Factor) ?
PS : don't speed too much to answer coz I'm off for one week, going skiing in the French Alps
proutil dbname -C dbanalys
I get the following informations about the 'INDEX BLOCK' :
INDEX BLOCK SUMMARY FOR AREA "Schema Area" : 6
-------------------------------------------------------
Table Index Fields Levels Blocks Size % Util Factor
1) Does the '% Util' column really indicate the use of the index ? Does it mean that each time a query is made on a table, this index is used ?
2) If it's a pourcentage , what is it related to ? e.g. What does mean 100% or 0% ?
3) Lastly, what's the meaning of the last column (Factor) ?
PS : don't speed too much to answer coz I'm off for one week, going skiing in the French Alps