Received: from sid.trust.ee (sid.trust.ee [194.204.23.180]) by hub.org
	(8.8.8/8.7.5) with ESMTP id NAA15089;
	Tue, 2 Jun 1998 13:07:43 -0400 (EDT)
Received: from trust.ee (wink.trust.ee [194.204.23.184])
	by sid.trust.ee (8.8.7/8.8.7) with ESMTP id UAA26005;
	Tue, 2 Jun 1998 20:09:59 +0300
Message-ID: <3574324D.8DE61386@trust.ee>
Date: Tue, 02 Jun 1998 20:11:41 +0300
From: Hannu Krosing <hannu@trust.ee>
X-Mailer: Mozilla 4.05 [en] (Win95; I)
MIME-Version: 1.0
To: David Hartwig <daveh@insightdist.com>
CC: "Jose' Soares Da Silva" <sferac@bo.nettuno.it>,
	PostgreSQL Interfaces <pgsql-interfaces@postgreSQL.org>,
	hackers postgres <pgsql-hackers@postgreSQL.org>
Subject: Re: [INTERFACES] ODBC is slow with M$-Access Report
References: <Pine.LNX.3.96.980601173507.10343A-100000@proxy.bazzanese.com>
	<35741E93.91DE9C4F@insightdist.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

David Hartwig wrote:
> 
> > 1. The PostgreSQL doesn't use the index with  "OR"  operator  and
> > so is not possible to define a multiple key to use with M$-Access
> > and we need to retreat using OID as primary keys (thanks to Byron
> > Nikolaidis and David Hartwig of insightdist.com that are doing a
> > really great job with ODBC driver), but with the obvious consequences.
> 
>  I am currently working on a solution as time will allow.   Hopefully part of 6.4
> 

Will this solution be in ODBC driver (rewrite ORs to UNION) or in 
the backend (fix the optimiser)?

------
Hannu