CMIS Student Groups Slow?
Queries involving student groups might be slow when the STUGROUPS table is involved. This is because SERCO developers seem to see no need to have as part of an index the field GROUPID, despite this being a necessary key when finding details which include teachers (TEACHINGROUPS). Creating an index with SetID and GroupID will significantly speed up any such queries (and will have a positive impact on the overall performance of the database).
I'm really posting this for my own future benefit.