From: "Brian Ray" <be_...@sbcglobal.net>
Date: Wed, 21 Nov 2007 19:42:16 GMT
Local: Wed, Nov 21 2007 2:42 pm
Subject: Re: Discrepency between SQL/MP Explain plan, actual sequence of IOs
"Keith" <kd...@acm.org> wrote in messagenews:email@example.com...
> This is pure speculation, but one thing that occurs to me is that theAha, that could be it, as the TABLE1 scan is by indexed columns only--no
> results from SQLSADISPLAY might look odd if the query was able to do
> the scan of table1 using only columns from the index. In such a case,
> I don't know what it would report in the SQLSA.
> I'd kind of expect it to give the index name as the table name and
> I believe the Explain makes it clear whether the query plan is to do
> Again, this is just speculation on my part -- I don't have any
base table predicate. The cursor does select un-indexed TABLE1 columns, but
only filters by indexed columns. On cursor open it could just be dealing
with TABLE1's index, which contains everything it needs for the WHERE clause
and for the inner join. Then on the actual fetch maybe it's going back and
picking up the other selected columns.
You must Sign in before you can post messages.
To post a message you must first join this group.
Please update your nickname on the subscription settings page before posting.
You do not have the permission required to post.