Re: [SQL] Interest query plan

[Tomasz Myrta]

Hi all,
I am running pg 7.3.1.
My query is very simple but pg generates not the best possible plan for
me:
 analyze select * from a_doc D left outer join (A_SKLAD S join A_MED M
ON(S.IDS_MED=M.IDS) )on( d.IDS=s.IDS_DOC)  where d.IDS='SOF_700060';
What about:

select * from a_doc D
 left join A_SKLAD S on(d.IDS=s.IDS_DOC)
 left join A_MED M ON(S.IDS_MED=M.IDS)
where d.IDS='SOF_700060'
?

Regards,
Tomasz Myrta


---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend