On Fri, Feb 25, 2022 at 3:18 PM Ayub Khan wrote:
> Hi,
>
> Could some some verify the attached query to verify the performance and
> suggest some steps to improve it, this query is created as a view. This
> view is used to get the aggregates of orders based on its current status
>
I don't see ho
On Sun, Feb 27, 2022 at 7:09 AM Kumar, Mukesh
wrote:
> Hi Team,
>
> Can you please help in tunning the attached query as , i am trying to run
> this query and it runs for several hours and it did not give any output.
>
Several hours is not all that long. Without an EXPLAIN ANALYZE, we could
eas
Hi,
On Sun, Feb 27, 2022 at 04:40:16AM +, Kumar, Mukesh wrote:
>
> Can you please help in tunning the attached query as , i am trying to run
> this query and it runs for several hours and it did not give any output.
>
> I am not able to generate the explain analyze plan as well and it keeps on
Hi Team,
Can you please help in tunning the attached query as , i am trying to run this
query and it runs for several hours and it did not give any output.
I am not able to generate the explain analyze plan as well and it keeps on
running for several hours and did not give output.
I have attac
