Re: [PERFORM] strange and slow joining of nested views

Titus von Boxberg writes: > I got the following problem for which I could not find a solution by > searching the archives: > I have Tables Ta, Tb, Tc with primary keys as bigserials. > Ta references Tb references Tc. > Not all but most rows in Ta reference exactly one row in Tb. Hm, your problem

[PERFORM] strange and slow joining of nested views

Dear all, I got the following problem for which I could not find a solution by searching the archives: I have Tables Ta, Tb, Tc with primary keys as bigserials. Ta references Tb references Tc. Not all but most rows in Ta reference exactly one row in Tb. Above the Tables I have views Va, Vb, Vc