# Missing index on series column in mh_search

## Description

mh_search has a series_id column, which should be indexed because SearchServiceDatabaseImpl.java runs the query Search.getNoSeries which queries for series missing a series id. Without this index, the db does a full table scan.

If you have a lot of episodes without a series, this could also be a performance concern (for every startup) regardless of the index.

Unassigned

Stephen Marquard

None

Major
Configure