PM yazan suleiman wrote:
> > I am evaluating postgres 9 to migrate away from Oracle. The following
> > query runs too slow, also please find the explain plan:
> First:
>
> explain analyze
> SELECT DISTINCT
> EVENT.ID
>,ORIGIN.ID AS ORIGINID
>,EVENT.PRE
am answering your question, but I don't have access to generate ddl
from Oracle. Thanks for the reply.
On Fri, Jan 28, 2011 at 12:50 PM, Kenneth Marshall wrote:
> On Fri, Jan 28, 2011 at 09:30:19AM -0800, yazan suleiman wrote:
> > I am evaluating postgres 9 to migrate away from Oracl
I am evaluating postgres 9 to migrate away from Oracle. The following query
runs too slow, also please find the explain plan:
explain analyze select DISTINCT EVENT.ID, ORIGIN.ID AS
ORIGINID,EVENT.PREFERRED_ORIGIN_ID AS PREFERRED_ORI
