Re: Multiple datasets in one dataset

On Oct 18, 7:53 am, roman.moroku..._at_googlemail.com wrote:
> > What is the execution plan? In SQL*Plus use the command (i hope i get
> > this right) "SET AUTOT TRACE EXP STAT", and run the query, then post
> > the output here.
>
> Well, this was indeed right. Congratulations.
>
> > Could those records bve ignored? If so, use a WHERE clause to exclude
> > such a case, such as, AND A.Value1 > 0 AND A.Value2 > 0 ... AND
> > A.Value10 > 0.
>
> This should be discussed. But I think they should be shown also.
>
> > (+) is Oracle specific, just like *= is SQL Server specific. All
> > support the ANSI syntax, however.
>
> I was aware of this, but to lazy to convert the statement into
> standard SQL ;-(
>
> > An EXPLAIN PLAN would probably be helpful here as well.
>

...
>
> The execution plan does not reveal any problem, I guess, whereas
> the plain statement does. It never returns.
>

Please let us know which exact version and platform you are using. There are some outer join bugs, but not generally on anything this simple AFAIK. Are you seeing your cpu pegged? Do you know how to check for wait states with Oracle? Anything else going wrong, errors in the alert log?

jg

--
@home.com is bogus.
virtually eliminated, huh-huh, huh-huh...
http://www.statesman.com/search/content/news/stories/local/10/09/1009tollglitch.html