Docstore Collection table join is making the query execution extremely slow

Team,

We have 2 Docstore/Collection tables. We need to join them and get appropriate data. We are facing following performance issues :

1. We need to create respective views as direct joining of these Docstores/collections is not allowed.

2. With large volume of data, it is taking huge time to execute the queries on joining these views.

Can someone please help us to solve this non-performant views' query execution issue ?