I did have index “symbol:1,end_dt:1” for pricedata collection
But because of lookup stage is using end_dt:-1 , I end up creating second index as symbol:1,end_dt:-1
after adding new index, lookup was faster comparatively previous scenario.
But my aggregation query is returning output with symbol asc order and end_dt in descending order.
when add additional stage after lookup with sort as symbol:1,end_dt:1 then it takes forever not sure why