Re: Understanding this query
Date: Thu, 27 May 2010 17:39:42 -0700 (PDT)
> 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