From 8ddc35a1ced32b40ef2ee333f2adcc57f3725811 Mon Sep 17 00:00:00 2001
From: Shadowghost <Ghost_of_Stone@web.de>
Date: Sat, 7 Feb 2026 00:56:38 +0100
Subject: Optimize Indices

---
 .../ModelConfiguration/BaseItemImageInfoConfiguration.cs             | 5 +----
 1 file changed, 1 insertion(+), 4 deletions(-)

(limited to 'src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/BaseItemImageInfoConfiguration.cs')

diff --git a/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/BaseItemImageInfoConfiguration.cs b/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/BaseItemImageInfoConfiguration.cs
index e835931b5f..79262e4c8d 100644
--- a/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/BaseItemImageInfoConfiguration.cs
+++ b/src/Jellyfin.Database/Jellyfin.Database.Implementations/ModelConfiguration/BaseItemImageInfoConfiguration.cs
@@ -15,10 +15,7 @@ public class BaseItemImageInfoConfiguration : IEntityTypeConfiguration<BaseItemI
         builder.HasKey(e => e.Id);
         builder.HasOne(e => e.Item).WithMany(e => e.Images).HasForeignKey(e => e.ItemId);
 
-        // Index for efficient lookups and deletes by ItemId
-        builder.HasIndex(e => e.ItemId);
-
-        // Composite index for filtering by item and image type
+        // Composite index for filtering by item and image type (also covers ItemId-only lookups)
         builder.HasIndex(e => new { e.ItemId, e.ImageType });
     }
 }
-- 
cgit v1.2.3