Re: Understanding this query

From: John Hurley <>
Date: Thu, 27 May 2010 17:39:42 -0700 (PDT)
Message-ID: <>


> 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