Add new index to node_field_revision

Problem/Motivation

Follow up from #2949939: The latest_revision ViewsFilter has poor performance

@dewalt

I propose also to add new index on node_field_revision table, in my case it extremely increase a performance:
- revision_translation_affected
- nid
- vid

Looks like temporary table constructed in $subquery isn't cached by MariaDB engine. We have much content and more that 100k revisions. Having a dashboard with 4 node revision views (each use "Is Latest Translation Affected Revision" filter) I have the next times of the page render (I make `drush cr` before each load):

Core: 7m 15s
Core+index: 40s
Patch #25: 3m 40s

Steps to reproduce

NA

Proposed resolution

TBD

Remaining tasks

TBD

User interface changes

TBD

API changes

TBD

Data model changes

TBD

Release notes snippet

TBD