[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Calculating % Utilization for Indexes with VSTs

Status
Not open for further replies.
R

Rob Fitzpatrick

Guest
Your current approach sounds reasonable. Is there a problem with it that makes you want to change? I think you'd be hard-pressed to find a better way to do this from the ABL. I don't know of any VST info that will give you insight into b-tree content. It's a good idea to be running regular dbanalys reports anyway; say, monthly. I wouldn't expect your index utilization to change so quickly or dramatically that parsing that monthly report wouldn't be good enough.

Continue reading...
 
Status
Not open for further replies.
Top