# SumIndexFields Property
> Version: _Available or changed with runtime version 1.0._
Specify which fields should be the "aggregation fields" in a SumIndexField Technology (SIFT) index, if applicable.
## Applies to
 Table key
## Syntax
```al
key(<key name>;<comma-separated list of lookup fields>) {
            SumIndexFields=<comma-separated list of aggregation fields>;
        }
```
## Example
```al
table 50100 Student
{
    DataClassification = CustomerContent;
    fields
    {
        field(1; Code; Text[50])
        {
            DataClassification = EndUserPseudonymousIdentifiers;
        }
        field(2; FirstNames; Text[100])
        {
            DataClassification = EndUserIdentifiableInformation;
        }
        field(3; ECTSPoints; Integer)
        {
            DataClassification = CustomerContent;
        }
        field(4; NumberOfCourses; Integer)
        {
            DataClassification = CustomerContent;
        }
    }
    // this defines a SIFT index on Code, FirstNames with aggregations fields for count, SUM(ECTSPoints), and SUM(NumberOfCourses)
    // Because MaintainSqlIndex is set to false, no non-clustered index is created on (Code,FirstNames)
    //
    keys
    {
        key(SIFTKeyOnCode;Code,FirstNames) {
            SumIndexFields=ECTSPoints,NumberOfCourses;
            MaintainSqlIndex = false;
        }
    }
}
```
## Remarks
You can select up to 20 SumIndexFields for each key.
The fields must be of a numeric datatype \(Decimal, Integer, BigInteger, or Duration\).
Changing existing keys may affect the behavior of the application since other parts of your application may depend on the existence of certain keys.
## Related information
devenv-properties
devenv-maintainsiftindex-property
devenv-maintainsqlindex-property
AL Data Types<../methods-auto/library>

Copyright (c) Microsoft Corporation. CC BY 4.0, https://creativecommons.org/licenses/by/4.0/; code samples MIT. From https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-sumindexfields-property, MicrosoftDocs/dynamics365smb-devitpro-pb at 828b6ee (2026-11-19). Changed: includes filled in, links to this site, and for agents shortened without dropping a fact. https://jonas-paprotka.de/docs/dev-itpro/developer/properties/devenv-sumindexfields-property/
