USE [Sporify]

GO
CREATE NONCLUSTERED INDEX [IX_EntityChangeset_AggregateName]
    ON [dbo].EntityChangeset(AggregateName);

GO
CREATE NONCLUSTERED INDEX [IX_EntityChangeset_Tenant_Time_Action]
ON [dbo].[EntityChangeset] (TenantId, [Timestamp], [Action], TableName)
INCLUDE (AggregateName, AggregatePK, UserId);