Re: Please help tuning a query

From: Ryan Gaffuri <rgaffuri_at_cox.net>
Date: 8 May 2003 05:09:16 -0700
Message-ID: <1efdad5b.0305080409.195c0f2a@posting.google.com>

"Anurag Varma" <avdbi_at_hotmail.com> wrote in message news:<cckua.4810$3x5.1985_at_news01.roc.ny.frontiernet.net>...
> "Ryan" <rgaffuri_at_cox.net> wrote in message news:lYeua.36572$g41.3165426_at_news1.east.cox.net...
> > is there anyway to get that plan to line up so people can read it? Im not
> > using tabs. Just the space bar?
> >
> >
>
> set linesize 120
> col plan_plus_exp format a99
>
> might help....
>
> Anurag

I know how to do it in SQL*Plus its the board that messing it up. Noone is going to want to read a plan posted like that.

I know the cursor select then update by rowid is faster. Its just building a bad plan. There are indices and it should not use a sort merge. Ill have to mess with it some more to figure out what is going on. Sort Merge = Death sentence for performance. Received on Thu May 08 2003 - 07:09:16 CDT