When we display list fields of given artifacts (at their last changeset), we often also need to get the list value's color badge (for example "On going" status value with a green color). However, there is no index on tracker_field_list_bind_decorator on value_id which matches the list field's platform-unique ID for the list value. It means that Cross-Tracker search query (and likely many other SQL queries) will do a full table scan on that table every time a query selecting @status or any static list field (for example Category, in this tracker) is used.

We should add this index.