You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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.
The text was updated successfully, but these errors were encountered:
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.
The text was updated successfully, but these errors were encountered: