Received: from mblox.com (unknown [213.155.153.59]) by postgresql.org (Postfix) with ESMTP id 761114765C3 for ; Mon, 8 Apr 2002 11:13:59 -0400 (EDT) Received: from salamander (salamander.mblox.com [::ffff:192.168.2.102]) (AUTH: LOGIN ian.cass) by aerosmith with esmtp; Mon, 08 Apr 2002 15:14:28 +0000 Message-ID: <00d401c1df0f$d445c410$6602a8c0@salamander> From: "Ian Cass" To: pgsql-sql@postgresql.org Cc: "Tom Lane" References: <002001c1def9$e0fcc750$6602a8c0@salamander> <20623.1018277168@sss.pgh.pa.us> Subject: Re: JOINS and non use of indexes Date: Mon, 8 Apr 2002 16:12:36 +0100 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200204/88 X-Sequence-Number: 7353 > There's your problem (and don't tell me Oracle gets this right; they > don't do inheritance, do they?). No, Oracle doesn't do inheritance. > The planner isn't smart about > indexscan-based joins for inheritance trees. This could possibly be > improved with some work, but I haven't thought about the details. Is there any way I could 'educate' it by using more explicit sql, or do I have to abandon the idea of using inheritance altogether? -- Ian Cass