I really need some ideas to overcome a dilemma with a query optimization
I have a report using a stored procedure This stored procedure is calling some tables on the sal server with a join to some external tables that reads some mongo collections
Now the question here is how can I optimize it?
Because right now this query is very heavy