On Tue, 19 Mar 2002 18:06:44 -0800
"Christian Cabanero" <chumpboy(at)yahoo(dot)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