Improve JournalArticleLocalization queries

• Type: Task
• Status: Closed
• Resolution: Completed
• Affects Version/s: 7.0.X, 7.1.X, 7.2.X, Master
• Fix Version/s: 7.3.1 CE GA2, 7.3.2 CE GA3, 7.3.10 DXP GA1, Master
• Component/s: ~[Archived] WCM
• Labels:
  • echo-board-out
  • ee-ts
• Git Pull Request: https://github.com/brianchandotcom/liferay-portal/pull/85227
• QA Test Name:
  • LocalFile.PortalSmoke#SmokeWithDeveloperProperties
• QA Test Score: 5

There are many queries in /portal-master/modules/apps/journal/journal-service/src/main/resources/META-INF/custom-sql/default.xml that filter based on JournalArticleLocalization.companyId and JournalArticleLocalization.articlePK, but there is no index that takes into account the companyId.