Page 8704 "Indexes List Part"

System Application · System.DataAdministration · captioned “Indexes” · BC28-30 · source at ea08af5e · 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
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 (main, BC30, feature)
2026-07-30 #9600 Uptake sift disable enable support (main, BC30, feature)

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.