spring-batch icon indicating copy to clipboard operation
spring-batch copied to clipboard

Improve recommendations for indexing metadata tables

Open vpavic opened this issue 1 year ago • 1 comments

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 avatar Feb 15 '24 22:02 vpavic