Config backend: low performance on loading large number of subnets

We have been chasing the problem with long time taking to fetch large number of subnets from the MySQL config backend. This was narrowed down as a problem with indexing on the dhcp4_options table referencing subnets. The indexing must be corrected and we need to investigate if there are other similar problems in the schema.