It's often useful to search for concepts using a mapping when working at API level (i.e. Context.getConceptService().getConceptByMapping(...)). This type of query is necessary for any modules that need to deal with standardized terminology.
However the code column on the concept_reference_term table isn't indexed. Adding this index would be of huge benefit for optimizing the getConceptByMapping query.