Currently when deleting from the schema_set_yang_resources table, the database is sequentially scanning instead of using an indexed search, as there are no indexes on the table.

This causes very poor performance. Adding an index for schema_set_id will allow for better performance when deleting schema sets.