| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORDER BY ..
is there really a paremeter other than sort_area_size,sort_direct_writes
which I am not aware of.
let me know cause u said there is a parameter that can make an ORDER BY
clause run faster. Although I do not recommend it as the answer
>From: Satar Naghshineh <Satar.Naghshineh_at_irvine.mellesgriot.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: RE: ORDER BY ..
>Date: Tue, 07 Nov 2000 15:35:44 -0800
>
>Ditto, Lee didn't do anything wrong. Also, if Patrice (spelling?) wants to
>answer questions like that, she'll spend all her time on the list. By the
>way, Patrice (spelling?) wouldn't be able to help the original poster by
>getting a copy of the original poster's script. Patrice will have to have
>the ERD and the knowledge of the business requirements.
>
>As funny as it seems, there is a parameter that can make an ORDER BY clause
>run faster. Although I do not recommend it as the answer, but one could set
>SORT_AREA_SIZE to a high number so all the sorting is done in memory.
>
>Regards,
>Satar
>
> > -----Original Message-----
> > From: Dennis Taylor [SMTP:ismgr_at_pctc.com]
> > Sent: Tuesday, November 07, 2000 9:33 PM
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: ORDER BY ..
> >
> > That was what I got as well.
> >
> > At 11:07 AM 11/7/00 -0800, you wrote:
> > >I may be wrong here but I was thinking that Lee was
> > >daring someone to reply to the list with that parameter
> > >that was going around as a joke before. I think
> > >it was _make_sql_run_faster. Hardly a cause for removing
> > >someone from the list.
> > >
> >
> > ---
> > Dennis Taylor
> > ---
> > Don't worry about people stealing your ideas. If your ideas
> > are any good,
> > you'll have to ram them down people's throats.
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Dennis Taylor
> > INET: ismgr_at_pctc.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
Share information about yourself, create your own public profile at Received on Wed Nov 08 2000 - 11:20:26 CST
 |
 |