Re: Query performance

On Wed, Oct 21, 2020 at 5:32 PM Nagaraj Raj <nagaraj(dot)sf(at)yahoo(dot)com> wrote:

> Hi, I have long running query which running for long time and its planner
> always performing sequnce scan the table2.
>

FROM sor_t.transfer_order_header hed,sor_t.transfer_order_item itm
> where hed.eventid=itm.eventid group by 1,2,3,4,5,6
>
> Any suggestions would greatly appretiated.
>

You aren't filtering out any rows so it is unsurprising that a sequential
scan was chosen to fulfil the request that the entire detail table be
consulted. The good news is you have access to parallelism - see if you
can increase that factor.

Any other suggestions probably requires more knowledge of your problem
domain than you've provided here.

Finding a way to add a where clause or compute your desired result during
record insertion or updating are two other potential avenues of
consideration.

David J.