---
id: post/sauravdhyani-com/tag-blogger-com-1999-blog-3122193036149030463-post-4052415603111434126--e2c225526c
type: post
title: Manage Database Index Usage in Business Central.
summary: Business Central 2026 Wave 1 enables administrators to manage database indexes directly from the client without SQL access. The feature allows viewing index metrics, disabling unused secondary indexes per company, and optimizing database storage and write performance.
tier: community
language: en
tags:
  - database performance
  - index management
  - storage optimization
  - administrative capabilities
  - business central 2026
system: administration
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:47:06.962Z"
  flags: []
generated:
  at: "2026-10-07T22:42:12.892Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: 3bf8de167d0f2a759adbb6fffb51f244d82d71d520b3c8ed3c203bdd938aba9d
evidence:
  - kind: blog
    url: https://www.sauravdhyani.com/2026/08/manage-database-index-usage-in-business.html
    title: Manage Database Index Usage in Business Central.
    date: "2026-08-24"
    commit: null
    t: null
    quote: null
  - kind: blog
    url: https://www.sauravdhyani.com/2026/08/manage-database-index-usage-in-business.html
    title: Manage Database Index Usage in Business Central.
    date: "2026-08-24"
    commit: null
    t: null
    quote: Administrators can now make informed optimization decisions directly from the Business Central client.
  - kind: blog
    url: https://www.sauravdhyani.com/2026/08/manage-database-index-usage-in-business.html
    title: Manage Database Index Usage in Business Central.
    date: "2026-08-24"
    commit: null
    t: null
    quote: Company A can have an index enabled. Company B can have the same index disabled.
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: tag:blogger.com,1999:blog-3122193036149030463.post-4052415603111434126
source_id: sauravdhyani-com
source_name: Saurav Dhyani
url: https://www.sauravdhyani.com/2026/08/manage-database-index-usage-in-business.html
published_at: "2026-08-24T05:30:00.000Z"
author: Saurav Dhyani
full_text: false
words: 730
quotes:
  - text: Administrators can now make informed optimization decisions directly from the Business Central client.
    why_it_matters: This eliminates the need for direct SQL tool access for database index management, making the capability more accessible to business administrators.
  - text: Company A can have an index enabled. Company B can have the same index disabled.
    why_it_matters: This multi-company flexibility allows tailored optimization for different organizational units with different workloads, reducing unnecessary overhead.
code_objects_mentioned: []
systems:
  - administration
  - platform
versions_mentioned:
  - Business Central 2026 Release Wave 1
preview:
  embeddable: true
  frame_url: null
  image: https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGcw6D6j3-WR5QcMWvGvpxvpCh_91rmzO7VYQo2SQuQZ6dpespyPyct64-7tSpTCmyXJIEcFF6AUOvsxLKFvjQsPnjaQgRtMS3gUPUl6ZtFP8gznpHiUQ7k03xZs3yjjpKNnRZ7xzAFFrSSxV6_5nClYSwb7D5bT_BirJp5zAw5piPHYj5H67HHGtly7A/w1200-h630-p-k-no-nu/ChatGPT%20Image%20Jul%2021,%202026,%2011_34_02%20PM.png
  image_alt: null
  image_w: null
  image_h: null
  site_name: null
  favicon: https://www.sauravdhyani.com/favicon.ico
  probed_at: "2026-10-07T11:50:10.346Z"
---

# Manage Database Index Usage in Business Central.

[Read the post](https://www.sauravdhyani.com/2026/08/manage-database-index-usage-in-business.html) · Saurav Dhyani (Saurav Dhyani, MVP) · 2026-08-24 · 730 words · tier community · reviewed (checked by Opus)

> Business Central 2026 Wave 1 enables administrators to manage database indexes directly from the client without SQL access. The feature allows viewing index metrics, disabling unused secondary indexes per company, and optimizing database storage and write performance.

## Key points

- Administrators can view index details (name, size, usage statistics, enabled status) through the Table Data Management page
- Company-specific index control allows different companies to have the same index enabled or disabled independently
- Only secondary indexes can be disabled; primary keys, unique indexes, SIFT indexes, and SystemId indexes remain protected
- Disabling indexes reduces storage usage and improves insert/update/delete performance; enabling is queued for the next midnight maintenance
- Index management requires reviewing usage statistics and testing in sandbox before production changes, as low usage during short periods may not indicate permanent irrelevance

## Quotes

- "Administrators can now make informed optimization decisions directly from the Business Central client." (This eliminates the need for direct SQL tool access for database index management, making the capability more accessible to business administrators.)
- "Company A can have an index enabled. Company B can have the same index disabled." (This multi-company flexibility allows tailored optimization for different organizational units with different workloads, reducing unnecessary overhead.)

## Context

- Features: Index Management, Table Data Management page, Index Usage Monitoring, Company-Level Index Control, Index Statistics Display
- Versions: Business Central 2026 Release Wave 1

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