Hi,
Could some some verify the attached query to verify the performance andsuggest some steps to improve it, this query is created as a view. Thisview is used to get the aggregates of orders based on its current status
Thanks