The OpenEdge DBA Files
This week, Patrice Perrot from PROGINOV joins Paul Koufalis to talk about deleted key placeholders.
After a massive data purge, you run idxcompact, right? You want to remove all those deleted key placeholders polluting your index.
Guess what? Idxcompact doesn't remove those placeholders the way you think it does.
What is a Deleted Key Placeholder?
From the Progress Documentation:
In today’s missive, we are going to talk about poor, misunderstood memory. How much is used? How much is free? How exactly do you define “used” and “free” memory? And the million dollar question: why should you care?
Every experienced IT person knows that bad things tend to happen on Fridays, and Friday evening is when we got alerted: major performance problems on the primary database server at one of our Enterprise clients.