I have two collections. One with product details
and another with product components
with one-to-many relationship. One product can have many product components. When I do a query with lookup it is too slow. I am just trying to retrieve 1000 documents from 3000. Do I have to add any index?