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

XML

Word

Printable

JSON

Details

Type: Sub-task
Status: Open
Priority: Major
Resolution: Unresolved
Affects Version/s: None
Fix Version/s: None
Component/s: Database/Schema
Labels:
- pull-request-available

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

Attachments

Issue Links

links to

GitHub Pull Request #3214

Activity

People

Assignee:: Janos Kovacs

Reporter:: Janos Kovacs

Votes:: 0 Vote for this issue

Watchers:: 3 Start watching this issue

Dates

Created:: 15/Apr/22 19:05

Updated:: 02/Sep/24 15:02

Time Tracking

Estimated:

Not Specified

Remaining:

0h

Logged:

2h 40m