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.
