Horton

Re: [INTERFACES] ODBC is slow with M$-Access Report

Hannu Krosing <hannu@trust.ee>

View thread
From: Hannu Krosing <hannu@trust.ee>
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>
Date: 1998-06-02T17:11:41Z
Lists: pgsql-hackers 
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