The Curse of Deleted Key Placeholders

Friday 15:00-16:00

Hosting and managing more than 10k Progress DB in our own Datacenters, we have to take care of the Deleted key Placeholders.

During this breakout session, we will go deeper using some illustrative examples.

We will cover:

  • What is a Deleted Key Placeholder?
    • Definition
    • When do they appear
  • Why Does It Matter (performance)?
    • DB access
    • Real Index %util
    • Index Level
  • How Can You Check Your DB?
    • 3 ways to estimate them
  • How Are These Placeholders Removed?
    • And when it does not happen
  • What Can You Do About It?