Date: Tue, 27 Nov 2007 21:29:25 -0800 (PST)
Local: Wed, Nov 28 2007 12:29 am
Subject: Re: Discrepency between SQL/MP Explain plan, actual sequence of IOs
On Nov 27, 12:27 pm, "Brian Ray" <be_...@sbcglobal.net> wrote:
> <HKREGCJAB...@spammotel.com> wrote in messageHey Brian,
> > On Nov 20, 11:34 am, "Brian Ray" <be_...@sbcglobal.net> wrote:
> [more snipping]
> > You might want to try a larger dataset with an ORDER BY clause (with
> I was hoping for this behavior in my tiny little inhouse pathway but for
> > Joe Bishop
> Heh, the Tandem world is too small a place for there to be two Joe Bishops.
I thought I recognized that name! I owe the FDS guys a visit too.
I did some more research, and I'm afraid I have to take back those
The revised version:
1. Read all the required data from the table with the smaller dataset
If the 2nd step uses an index (or primary key), the rows are returned
Therefore, to avoid a sort, the index could only begin to be accessed
I still think you'd get better performance by forcing a nested join
Good to see that many of the old FDS crowd are still in the Tandem
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.