---
id: post/sauravdhyani-com/tag-blogger-com-1999-blog-3122193036149030463-post-3728891053687741480--7cb5bca9a9
type: post
title: "Business Central 2026 Release Wave 2: Turn SIFT Indexes On or Off"
summary: Starting with Business Central 2026 Release Wave 2, administrators can now turn SIFT (SumIndexField Technology) indexes on or off directly in the application through Table Information. This feature provides operational control over database performance by allowing targeted index management based on actual usage patterns without requiring developer changes or application modifications.
tier: community
language: en
tags:
  - database performance
  - sift indexes
  - index management
  - table information
  - aggregation performance
  - write performance
  - operational tuning
system: platform
review:
  state: reviewed
  by: opus
  at: "2026-10-07T23:46:09.790Z"
  flags: []
generated:
  at: "2026-10-07T22:42:12.892Z"
  pipeline: 0.2.0
  prompts:
    extract-post: 1
  input_hash: 9d896f97a6bcd669a1f79dbd0a1e4203bb00a368ccf0843a511f5d517c444b03
evidence:
  - kind: blog
    url: https://www.sauravdhyani.com/2026/09/business-central-2026-release-wave-2_01917375766.html
    title: "Business Central 2026 Release Wave 2: Turn SIFT Indexes On or Off"
    date: "2026-10-07"
    commit: null
    t: null
    quote: null
  - kind: blog
    url: https://www.sauravdhyani.com/2026/09/business-central-2026-release-wave-2_01917375766.html
    title: "Business Central 2026 Release Wave 2: Turn SIFT Indexes On or Off"
    date: "2026-10-07"
    commit: null
    t: null
    quote: Business Central administrators can now turn SIFT indexes on or off directly from the application.
  - kind: blog
    url: https://www.sauravdhyani.com/2026/09/business-central-2026-release-wave-2_01917375766.html
    title: "Business Central 2026 Release Wave 2: Turn SIFT Indexes On or Off"
    date: "2026-10-07"
    commit: null
    t: null
    quote: The goal is not to have fewer indexes. The goal is to have the right indexes for the workload.
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
post_id: tag:blogger.com,1999:blog-3122193036149030463.post-3728891053687741480
source_id: sauravdhyani-com
source_name: Saurav Dhyani
url: https://www.sauravdhyani.com/2026/09/business-central-2026-release-wave-2_01917375766.html
published_at: "2026-10-07T05:30:00.000Z"
author: Saurav Dhyani
full_text: false
words: 1605
quotes:
  - text: Business Central administrators can now turn SIFT indexes on or off directly from the application.
    why_it_matters: This is the core new capability introduced in 2026 Wave 2, enabling operational control without developer involvement
  - text: The goal is not to have fewer indexes. The goal is to have the right indexes for the workload.
    why_it_matters: Clarifies that index management should be evidence-based and workload-specific, not about blanket disabling
code_objects_mentioned: []
systems:
  - platform
  - administration
versions_mentioned:
  - 2026 Release Wave 2
  - 2026 Release Wave 1
  - Business Central 29
preview:
  embeddable: true
  frame_url: null
  image: https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiGJXCV-RMxwuUh9VXyYlGBhTXDD9r9znsjBoLLpjSD8lBErfWBf6GmuDq36BAev_8JOQzLsai31qd6d-7S5YSvjpXXAsuSSt3e0Gh9uulXz6nwhqehjpLrAnrydTdQabTj_GY6Kq2qxiGGhZZ76zYrExpBSKqdP_z_xBTclusV4MXIQhKiiSPn94mBUxo/w1200-h630-p-k-no-nu/image1789016842
  image_alt: null
  image_w: null
  image_h: null
  site_name: null
  favicon: https://www.sauravdhyani.com/favicon.ico
  probed_at: "2026-10-07T11:49:40.306Z"
---

# Business Central 2026 Release Wave 2: Turn SIFT Indexes On or Off

[Read the post](https://www.sauravdhyani.com/2026/09/business-central-2026-release-wave-2_01917375766.html) · Saurav Dhyani (Saurav Dhyani, MVP) · 2026-10-07 · 1605 words · tier community · reviewed (checked by Opus)

> Starting with Business Central 2026 Release Wave 2, administrators can now turn SIFT (SumIndexField Technology) indexes on or off directly in the application through Table Information. This feature provides operational control over database performance by allowing targeted index management based on actual usage patterns without requiring developer changes or application modifications.

## Key points

- SIFT indexes maintain pre-calculated aggregate information using SQL indexed views to speed up sum and count calculations on large tables
- Enabling SIFT improves read performance for aggregations but creates maintenance overhead during insert, update, and delete operations
- Administrators can now manage SIFT indexes per company in multi-company environments through the Table Information page and data-management view
- Disabling SIFT should be based on evidence-driven analysis of workload and usage patterns, not automatic decisions based on low usage statistics
- This feature creates better separation between developer data-model design, consultant workload analysis, and operational index management

## Quotes

- "Business Central administrators can now turn SIFT indexes on or off directly from the application." (This is the core new capability introduced in 2026 Wave 2, enabling operational control without developer involvement)
- "The goal is not to have fewer indexes. The goal is to have the right indexes for the workload." (Clarifies that index management should be evidence-based and workload-specific, not about blanket disabling)

## Context

- Features: SIFT index management, Table Information page, Index on/off toggle, Per-company index control, Index usage visibility, Data-management view
- Versions: 2026 Release Wave 2, 2026 Release Wave 1, Business Central 29

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