RE: ORDER BY ..

Ok, Ok, Ok:

There are several init.ora options available (this part is humor :):

	_make_sorts_faster=true			(Oracle 7.4 & 8.0)
	_make_sorts_faster=<n>			(Oracle 8i, n=1..10)
	_make_sorts_faster=<n|unlimited)	(Oracle 9i)

But seriously, you can up the memory allocated to sort operations by increasing

        sort_area_size

Depending on the query, you may be able to add indexes to tables so that the ORDER BY is resolved during the index-range scan rather than having an actual sort performed.

Kevin         

> -----Original Message-----
> From: lerobe - Lee Robertson [mailto:LEROBE_at_acxiom.co.uk]
> Sent: Tuesday, November 07, 2000 11:36 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: ORDER BY ..
>
>
> GO ON - I DARE ONE OF YOU !!!!!
>
>
>
> -----Original Message-----
> [mailto:Marcos.Vera_at_msconsultores.com.pe]
> Sent: 07 November 2000 15:26
> To: Multiple recipients of list ORACLE-L
>
>
>
>
>
> i want my 'order by' transaction to be quick...very quick ...
> what oracle parameter should i increase or decrease ???
>
> Thanks a lot .
>
>
>
>
>
>
>
>
> "bunyamin karadeniz" <bunyamink_at_havelsan.com.tr> on
> 07/11/2000 02:55:22 AM
>
> Please respond to ORACLE-L_at_fatcity.com
>
>
>
>
>
>
>
>
>
>
>
> To: Multiple recipients of list ORACLE-L
> <ORACLE-L_at_fatcity.com>
>
> cc: (bcc: Marcos Vera/M&S Consultores/51)
>
>
>
> Subject: Re: Query to select only the duplicate records from
> a table?
>
>
>
>
>
>
>
>
> SELECT interested_columns
> FROM table_name a
> WHERE rowid >(SELECT min(rowid)
> FROM table_name b
> WHERE b.pk_column = a.pk_column ) ;
>
> *pk_coloumn is the primary key column the table.
> if you want to delete the duplicate rows, just change the
> select to DELETE
>
> ****** if you want to leave only one row of the duplicated
> rows,For ex: you
> have 3 duplicated rows and want to delete 2 of them and leave
> only one, The
> only possibility as I understand is first selecting the
> duplicate rows with
> DISTINCT and then insert into another table and then delete
> duplicated rows
> from the base table and select from second table and insert into base
> table.******
>
>
> **********************************************
> Bunyamin K. Karadeniz
> Enformasyon Teknolojileri Dir.
> Veri Tabani Grubu tel : 2873565/1681
> HAVELSAN
> **********************************************
>
> > -----Original Message-----
> > To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> > Date: Monday, November 06, 2000 2:38 PM
> >
> >
> > >Hello Lists,
> > >
> > >Can any body help me in writing a query which will
> > >list only the duplicate records from a table?
> > >
> > >Any help would be highly appreciated.
> > >
> > >TIA,
> > >Muru
> > >
> > >__________________________________________________
> > >Do You Yahoo!?
> > >Thousands of Stores. Millions of Products. All in one Place.
> > >http://shopping.yahoo.com/
> > >--
> > >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > >--
> > >Author: Murugesan Balakrishnan
> > > INET: mail_oracle_at_yahoo.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).
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: Jim Walski
> > INET: jwalski3_at_classicplan.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).
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: bunyamin karadeniz
> INET: bunyamink_at_havelsan.com.tr
>
> 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).
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Marcos.Vera_at_msconsultores.com.pe
>
> 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).
>
>
> The information contained in this communication is
> confidential, is intended only for the use of the recipient
> named above, and may be legally privileged. If the reader
> of this message is not the intended recipient, you are
> hereby notified that any dissemination, distribution or
> copying of this communication is strictly prohibited.
> If you have received this communication in error, please
> re-send this communication to the sender and delete the
> original message or any copy of it from your computer
> system.
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: lerobe - Lee Robertson
> INET: LEROBE_at_acxiom.co.uk
>
> 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
Received on Tue Nov 07 2000 - 11:37:44 CST