Hi,
I have two collections. One with product details
{
product_id:…,
product_name:…
}
and another with product components
{
product_id:…,
component_name:…,
…
}
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?