---
id: post/waldo-be/318212
type: post
title: Troubleshooting Series – Ep3 – Missing Indexes
summary: Troubleshooting missing indexes in Business Central SaaS environments requires understanding the Missing Indexes page, which reflects SQL DMV data that resets after server restart. Since developers can only add indexes through apps, careful analysis using telemetry to track missing indexes over time helps identify which indexes are truly necessary before implementation.
tier: community
language: en
tags:
  - indexes
  - performance troubleshooting
  - database optimization
  - telemetry
  - sql
  - missing indexes
system: platform
review:
  state: reviewed
  by: opus
  at: "2026-10-08T01:59:35.159Z"
  flags: []
generated:
  at: "2026-10-08T01:26:53.141Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: 4b205b737b1a7e795e37e5fd346f8564b2e55bc4dbc027a0489d2ee196171113
evidence:
  - kind: blog
    url: https://waldo.be/2025/08/29/troubleshooting-series-ep3-missing-indexes/
    title: Troubleshooting Series – Ep3 – Missing Indexes
    date: "2025-08-29"
    commit: null
    t: null
    quote: null
  - kind: blog
    url: https://waldo.be/2025/08/29/troubleshooting-series-ep3-missing-indexes/
    title: Troubleshooting Series – Ep3 – Missing Indexes
    date: "2025-08-29"
    commit: null
    t: null
    quote: The only way to add indexes, is through development.
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: "318212"
source_id: waldo-be
source_name: waldo's blog
url: https://waldo.be/2025/08/29/troubleshooting-series-ep3-missing-indexes/
published_at: "2025-08-29T06:00:00.000Z"
author: waldo (Eric Wauters)
full_text: true
words: 962
quotes:
  - text: The only way to add indexes, is through development.
    why_it_matters: Clarifies that index management requires code changes through apps, not UI configuration, which impacts implementation strategy.
code_objects_mentioned: []
systems:
  - platform
  - development
  - administration
versions_mentioned: []
preview:
  embeddable: true
  frame_url: https://waldo.be/2025/08/29/troubleshooting-series-ep3-missing-indexes/embed/
  image: https://waldo.be/wp-content/uploads/2025/08/image.png
  image_alt: null
  image_w: 499
  image_h: 269
  site_name: null
  favicon: https://waldo.be/wp-content/uploads/2019/06/waldo_logo_final_symbol_icon_Revised-150x150.ico
  probed_at: "2026-10-07T11:50:58.636Z"
---

# Troubleshooting Series – Ep3 – Missing Indexes

[Read the post](https://waldo.be/2025/08/29/troubleshooting-series-ep3-missing-indexes/) · waldo's blog (waldo (Eric Wauters), MVP) · 2025-08-29 · 962 words · tier community · reviewed (checked by Opus)

> Troubleshooting missing indexes in Business Central SaaS environments requires understanding the Missing Indexes page, which reflects SQL DMV data that resets after server restart. Since developers can only add indexes through apps, careful analysis using telemetry to track missing indexes over time helps identify which indexes are truly necessary before implementation.

## Key points

- Indexes can only be added by development, through an AppSource app or a PTE, not through configuration.
- The Missing Indexes page mirrors an in-memory SQL DMV that resets on restart; the author suspects it also resets when the database moves servers, so the snapshot may be very old or very new.
- Estimated Benefit combines seeks, scans, average cost and average impact, and is the field to prioritize.
- Sending daily snapshots of missing indexes to telemetry, as the iFacto Telemetry app does, allows trend analysis across customers, apps and tables.
- AppSourceCop allows removing or changing your own keys, but with no index usage statistics, removing indexes cannot be justified by data.

## Quotes

- "The only way to add indexes, is through development." (Clarifies that index management requires code changes through apps, not UI configuration, which impacts implementation strategy.)

## Context

- Features: Missing Indexes page, Estimated Benefit calculation, telemetry tracking, index management

Source: waldo's blog, community blog. Summary, key points and quotes are derived (CONTENT-NOTICE.md); read the original for the full text.