Skip to content

Create index for query statement and remove useless index#1214

Merged
HaiHui886 merged 1 commit into
mainfrom
sync_mr_2663_defe2e2
Jun 26, 2026
Merged

Create index for query statement and remove useless index#1214
HaiHui886 merged 1 commit into
mainfrom
sync_mr_2663_defe2e2

Conversation

@csg-pr-bot

@csg-pr-bot csg-pr-bot commented Jun 26, 2026

Copy link
Copy Markdown
Collaborator

Summary:

  • Created a new composite index idx_acct_statment_useruuid_scene_cusid_createdat on account_statements to align with actual query patterns for filtering and sorting.
  • Removed four redundant or ineffective indexes that increased write overhead without improving query performance, as their functionality is now covered by the new composite index.

@csg-pr-bot

csg-pr-bot commented Jun 26, 2026

Copy link
Copy Markdown
Collaborator Author

Depends on #1213

@csg-pr-bot csg-pr-bot mentioned this pull request Jun 26, 2026
Merged
HaiHui886
HaiHui886 approved these changes Jun 26, 2026
View reviewed changes

@HaiHui886 HaiHui886 left a comment

Copy link
Copy Markdown
Collaborator

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

lgtm

@HaiHui886 HaiHui886 merged commit 02e58df into main Jun 26, 2026
7 checks passed
@HaiHui886 HaiHui886 deleted the sync_mr_2663_defe2e2 branch June 26, 2026 14:04
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Reviewers

@HaiHui886 HaiHui886 HaiHui886 approved these changes

Assignees

No one assigned

Labels

None yet

Projects

None yet

Milestone

No milestone

Development

Successfully merging this pull request may close these issues.

2 participants

@csg-pr-bot @HaiHui886