| 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
>>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).
> >_________________________________________________________________________ >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. > >Share information about yourself, create your own public profile at >http://profiles.msn.com. > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: ARUN K C > INET: arun_k_c_at_hotmail.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). _________________________________________________________________________Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Share information about yourself, create your own public profile at Received on Wed Nov 08 2000 - 12:10:13 CST
 |
 |