How to improve the performance of a query execution with bigger resultset in spring

I have a native query inside my Java Spring application that hits an oracle DB and fetches a large resultset (close to 20000 records). Current approach is that I used Spring’s JdbcTemplate to execute the query, which takes about few minutes to execute the query. What will be the better approach to improve the performance in executing this query?

Source: oracle

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.