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
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