Views/queries and optimal indexes usage (cf. planner)

From: Cédric Dufour <cedric(dot)dufour(at)freesurf(dot)ch>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: Views/queries and optimal indexes usage (cf. planner)
Date: 2002-08-07 11:49:11
Message-ID: NDBBIFNBODNADCAOFDOACELBCDAA.cedric.dufour@freesurf.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Browse pgsql-sql by date

  From Date Subject
Next Message Jeff Eckermann 2002-08-07 13:35:24 Re: control reaches end of trigger procedure without RETURN
Previous Message Richard Huxton 2002-08-07 08:30:25 Re: Limit A Table To 1 Row