[HIVE-26144] Add keys/indexes to support highly concurrent workload

• Type: Sub-task
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Component/s: Database/Schema
• Labels: pull-request-available
• Assignee: Janos Kovacs
• Reporter: Janos Kovacs
• Created: 15/Apr/22 19:05
• Updated: 15/Aug/22 00:22

Description

The following indexes are added to avoid full table-scan in backend rdbms: 

• primary key for COMPLETED_TXN_COMPONENTS
• primary key for TXN_COMPONENTS
• index for TXN_WRITE_NOTIFICATION_LOG

Issue Links

• links to: GitHub Pull Request #3214