ODM models define separate indices for fields that should share a compound index

[bkis]

For example, the ContentBaseDocument model defines collection indices as follows:

class ContentBaseDocument(ContentBase, DocumentBase):
    class Settings(DocumentBase.Settings):
        name = "contents"
        is_root = True
        indexes = [
            "resource_id",
            "location_id",
            "archive_ts",
        ]

...but should instead define one index including all the desired fields:

class ContentBaseDocument(ContentBase, DocumentBase):
    class Settings(DocumentBase.Settings):
        name = "contents"
        is_root = True
        indexes = [
            [
                "resource_id",
                "location_id",
                "archive_ts",
            ]
        ]

The outer list is for multiple dedicated indices, the inner list defines the fields included in one index. This has to be checked and corrected for every ODM model.