---
id: object/page/8704
type: object
title: Page 8704 "Indexes List Part"
summary: Page 8704 "Indexes List Part" in System Application (System.DataAdministration). 1 public procedures. Introduced in BC28, still in BC30, changed in BC29.
tier: official
language: en
tags:
  - page
  - system application
versions:
  introduced: "28"
  last_changed: "29"
  deprecated: null
review:
  state: derived
  by: null
  at: null
  flags: []
generated:
  at: "2026-10-11T00:31:51.816Z"
  pipeline: 0.2.0
  prompts: {}
  input_hash: 59d1963aa309b5cd3041d53adbddce82bb083e79219a44e4968bfe6c5c4c3040
evidence:
  - kind: code
    url: https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/System%20Application/App/Table%20Information/src/IndexesListPart.Page.al
    title: src/System Application/App/Table Information/src/IndexesListPart.Page.al (releases/29.x)
    date: null
    commit: ea08af5ef2d6a9b5c5af4a029288abbe2c883220
    t: null
    quote: null
links:
  learn: []
  objects: []
  features: []
  topics: []
  localizations: []
  videos: []
  posts: []
  guidelines: []
  changes:
    - change/bcapps/10149
    - change/bcapps/9600
object_type: page
object_id: 8704
name: Indexes List Part
caption: Indexes
namespace: System.DataAdministration
app: System Application
extends: null
first_version: "28"
last_version: "30"
present_in:
  - "28"
  - "29"
  - "30"
changed_in:
  - "29"
source_major: "29"
obsolete: null
countries: []
ms_search_form_ids: []
counts:
  fields: 0
  procedures: 7
  events: 0
  subscribers: 0
  controls: 16
  actions: 4
relations:
  out: 0
  referenced_by: 0
  pages: 0
  extended_by: 0
  event_subscribers: 0
  calls: 0
  called_by: 0
  implements: 0
---

# Page 8704 "Indexes List Part"

> Page 8704 "Indexes List Part" in System Application (System.DataAdministration). 1 public procedures. Introduced in BC28, still in BC30, changed in BC29.

System Application · System.DataAdministration · captioned "Indexes" · BC28-30 · [source at ea08af5e](https://github.com/microsoft/BCApps/blob/ea08af5ef2d6a9b5c5af4a029288abbe2c883220/src/System%20Application/App/Table%20Information/src/IndexesListPart.Page.al) · facts from BC29

## Properties

| Property | Value |
|---|---|
| Caption | Indexes |
| SourceTable | Database Index |
| PageType | ListPart |
| ApplicationArea | All |
| Permissions | tabledata "Key" = r, tabledata "Database Index" = r |

## Fields on this page

Layout controls in source order, grouped by the container they sit in. Shows: the table field a control is bound to (or its expression as written); ToolTip: the control's own, else the bound field's (marked).

| Group | Control | Shows | ToolTip |
|---|---|---|---|
| Indexes | Index Name | `Rec."Index Name"` | Specifies the name of the index. |
|  | Index Type | `Rec."Index Type"` | Specifies whether the row represents a regular database index or a SIFT structure. |
|  | Enabled in Database | `Rec.Enabled` | Specifies whether the index is enabled in the database. |
|  | AL Defined | `Rec."Metadata Defined"` | Specifies whether the index is defined as an AL key or automatically created to improve performance. |
|  | Unique | `Rec.Unique` | Specifies whether the index is defined as unique in AL. |
|  | Fragmentation (%) | `Rec."Fragmentation %"` | Specifies the percentage of fragmentation in the index. |
|  | Index Size (kB) | `Rec."Index Size (KB)"` | Specifies the size of the index in kilobytes. |
|  | Seeks | `Rec."User seeks"` | Specifies the number of user seeks on this index since the database was last started. |
|  | Scans | `Rec."User scans"` | Specifies the number of user scans on this index since the database was last started. |
|  | Lookups | `Rec."User lookups"` | Specifies the number of user lookups on this index since the database was last started. |
|  | Updates | `Rec."User updates"` | Specifies the number of user updates on this index since the database was last started. |
|  | Last Seek | `FormatDateTime(Rec."Last seek")` | Specifies the timestamp of the last user seek on this index since the database was last started. |
|  | Last Scan | `FormatDateTime(Rec."Last scan")` | Specifies the timestamp of the last user scan on this index since the database was last started. |
|  | Last Lookup | `FormatDateTime(Rec."Last lookup")` | Specifies the timestamp of the last user lookup on this index since the database was last started. |
|  | Last Update | `FormatDateTime(Rec."Last update")` | Specifies the timestamp of the last user update on this index since the database was last started. |
|  | Statistics updated at | `FormatDateTime(Rec."Statistics rebuild at")` | Specifies the last time the index's corresponding statistics was rebuild. Statistics are updated automatically by the database engine based on certain thresholds of data changes, or when an index is re-enabled. |

## Actions

| Group | Action | ToolTip | Runs |
|---|---|---|---|
| Processing | Turn index off | Turn off the index in the database. For non-AL defined indexes, this action cannot be undone, for AL-defined indexes, the index can be re-created by enabling it again. |  |
|  | Turn index off (all companies) | Turn off the index in the database in all companies. For non-AL defined indexes, this action cannot be undone, for AL-defined indexes, the index can be re-created by enabling it again. |  |
|  | Turn index on | Enqueues the index to be turned on in the subsequent maintenance window. |  |
|  | Turn index on (all companies) | Enqueues the index to be turned on for all companies in the subsequent maintenance window. |  |

## Procedures

- `SetCompanyFilter(NewCompanyName: Text)`

Plus 6 local procedures.

## Triggers

OnFindRecord

## Recent changes

- 2026-08-20 [#10149 Improve the Index Mgmt page discoverability](../../changes/bcapps/10149.md) (main, BC30, feature)
- 2026-07-30 [#9600 Uptake sift disable enable support](../../changes/bcapps/9600.md) (main, BC30, feature)

## Across versions

- Present in: BC28-30
- Changed (declaration) in: BC29

Source: AL metadata extracted from the code (names, ids, signatures, properties); no code bodies (D10).

## Ask your agent

Procedure bodies are not stored here (D10). For a procedure body or the calls of one procedure, ask bc-code-atlas (external, by Stefan Maron, MIT; default corpus w1-28), which the bc-observatory plugin connects: `bcatlas_resolve_node(object_type: "page", object_name: "Indexes List Part")`, then `bcatlas_get_procedure_body` or `bcatlas_get_neighbors` on the returned id.