Re: Understanding this query

From: John Hurley <hurleyjohnb_at_yahoo.com>
Date: Thu, 27 May 2010 17:39:42 -0700 (PDT)
Message-ID: <c7663df0-415c-4989-8bde-07a78712f4ed_at_l6g2000vbo.googlegroups.com>



Magnet:

> Ok, we have a VERY complex query here which is dynamically made.  The
> issue we are having is this:
>
> Take a look at the inner part of the query, there is a dynamic column
> with some XMLAGG functions called "tag_list".
>
> If I do not place that column in the outer most part of the query, it
> runs in like .1.  However, if I put the "tag_list" column as part of
> the return set it takes 2 seconds.

Start with a 10046 trace of both variations of the query. Put them thru a resource profiler.

What are the difference in resource usages? What are the differences in waits?

Go from there ... Received on Thu May 27 2010 - 19:39:42 CDT

Original text of this message