Query taking time to return only 533 rows of data using spring jpa need help adding indexing to entity classes

Job ID: 37495391

Budget: £10 – £20 GBP

I have created a query that joins a few tables and it is really slow, taking 1 min to return 533 rows of data. I am using spring JPA and i need assistance in creating the indexing on the entity classes