Re: [PERFORM] Explicit joins

2011-05-05 Thread Kevin Grittner
Rishabh Kumar Jain 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 word

[PERFORM] Explicit joins

2011-05-04 Thread Rishabh Kumar Jain
I referred chapter 14.3 of postgres document version 9.0. explicit joins help the planner in planninng & thus improve performance. On what relations are explicit joins to be added?? 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 im