Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Improve recommendations for indexing metadata tables #4551

Open
vpavic opened this issue Feb 15, 2024 · 0 comments
Open

Improve recommendations for indexing metadata tables #4551

vpavic opened this issue Feb 15, 2024 · 0 comments

Comments

@vpavic
Copy link

vpavic commented Feb 15, 2024

Recommendations for Indexing Metadata Tables section of the reference manual provides some guidance for indexing Spring Batch tables. However, this is focused solely on where clauses in SQL statements while it should arguably also consider foreign keys as indexing those plays important role in speeding up queries involving joins.

On PostgreSQL, detecting such columns can be done using something like this.

@vpavic vpavic added the status: waiting-for-triage Issues that we did not analyse yet label Feb 15, 2024
@fmbenhassine fmbenhassine added in: documentation type: enhancement and removed status: waiting-for-triage Issues that we did not analyse yet labels Feb 16, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants