Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 02301475A4F for ; Wed, 7 Aug 2002 07:49:12 -0400 (EDT) Received: from aristote20.infomaniak.ch (aristote20.infomaniak.ch [212.23.249.228]) by postgresql.org (Postfix) with ESMTP id CDB8C475A57 for ; Wed, 7 Aug 2002 07:49:10 -0400 (EDT) Received: from ced001 (unverified [213.221.146.181]) by aristote20.infomaniak.ch (Rockliffe SMTPRA 4.5.6) with ESMTP id for ; Wed, 7 Aug 2002 13:49:02 +0200 From: =?iso-8859-1?Q?C=E9dric_Dufour?= To: Subject: Views/queries and optimal indexes usage (cf. planner) Date: Wed, 7 Aug 2002 13:49:11 +0200 Message-ID: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0042_01C23E19.35D9DCD0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) Importance: Normal X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200208/130 X-Sequence-Number: 8976 This is a multi-part message in MIME format. ------=_NextPart_000_0042_01C23E19.35D9DCD0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit 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 ------=_NextPart_000_0042_01C23E19.35D9DCD0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hello,
 
Assuming = I have some=20 tables A, B, C, ... that I CROSS-/LEFT-JOIN in a query/view, what are = the=20 guidelines to make sure the planner will use existing indexes on these= =20 tables when issuing WHERE or ORDER BY clauses ? What if I use subviews/subq= uery=20 ?
 
Is there = any=20 PostgreSQL documentation on the subject ? Or any other=20 documentation relevant for PostgreSQL's planner ?
 
C=E9dric=20 Dufour
 
------=_NextPart_000_0042_01C23E19.35D9DCD0--