Optimize Indices

1 files changed, 1 insertions, 4 deletions

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 });
     }
 }