Rishabh Kumar Jain <rishabh.widu@xxxxxxxxx> wrote: > I am getting data from 10 tables in a view. > I don't know on which pair of tables I have to add explicit joins > to improve performance. There's usually some fairly natural order in terms of understanding the request. I find it's often good to try to state in words what data I want to see (*not* how I think I could get that data, but describe logically which set of data I want), and list the tables in the order the appear in that description. The description will naturally tend to include or imply your join conditions and other selection criteria. -Kevin -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
