Hello,
Assuming I have some tables A, B, C, ... that I CROSS-/LEFT-JOIN in a query/view, what are the guidelines to make sure the planner will use existing indexes on these tables when issuing WHERE or ORDER BY clauses ? What if I use subviews/subquery ?
Is there any PostgreSQL documentation on the subject ? Or any other documentation relevant for PostgreSQL's planner ?
Cédric Dufour