Re: SQL Server performing much better?!?! - Mailing list pgsql-general

From Masaru Sugawara
Subject Re: SQL Server performing much better?!?!
Date
Msg-id 20020320222429.94D0.RK73@sea.plala.or.jp
Whole thread Raw
In response to SQL Server performing much better?!?!  ("Christian Cabanero" <chumpboy@yahoo.com>)
List pgsql-general
On Tue, 19 Mar 2002 18:06:44 -0800
"Christian Cabanero" <chumpboy@yahoo.com> wrote:

> (all monitored from top).  From the plan it looks like it's using indexes
> where appropriate and when it does do a table scan the cost doesn't seem to
> be that much.  The big operations seem to be when merge joins are performed.
> I've included both the query and the plan bellow.


 In case of using EXISTS clauses, it seems to be sometimes the case
that the results, for which those who execute queries are all agog, are not
returned quickly.


Regards,
Masaru Sugawara



pgsql-general by date:

Previous
From: Hans-Jürgen Schönig
Date:
Subject: Passing parameters to triggers
Next
From: "UAP2"
Date:
Subject: plpgsql function docs