•  
      request #10127 Missing index related to artifact links type
    Infos
    #10127
    Manuel Vacelet (vaceletm)
    2017-04-06 16:45
    2017-04-05 18:00
    10407
    Details
    Missing index related to artifact links type

    The code is issuing a lot of queries like:

    SELECT DISTINCT nature
    FROM tracker_changeset_value_artifactlink
    WHERE group_id = N
    ORDER BY nature ASC;

    or

    UPDATE tracker_changeset_value_artifactlink SET keyword='S' WHERE keyword='S' AND group_id='S'

    We need an index to cover that

    Trackers
    9.5
    Empty
    • [ ] enhancement
    • [ ] internal improvement
    Empty
    Stage
    Empty
    Closed
    2017-04-06
    Attachments
    Empty
    References

    Follow-ups