| 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 ..
I may be wrong here but I was thinking that Lee was=20
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.
-----Original Message-----
From: Boivin, Patrice J [mailto:BoivinP_at_mar.dfo-mpo.gc.ca]
Sent: Tuesday, November 07, 2000 9:56 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORDER BY ..
Jared,
Could you bump Lee off the list, there is no need to reply in this =
manner,
especially when the other person's first language is obviously not =
English.
Vera,
ORDER BY is a clause, not a transaction, but I know what you were =
trying to
get across.
Unfortunately it's not that simple, there are a lot of factors that =
make
queries (and transactions) run slowly. It depends on hardware, on some
initialization parameters, on whether indexes exist on the tables you =
are
querying, and on the order in which items are placed in your query. =
That's
not the end of it, though, there are many other factors to consider. =
It
takes months if not years to get to a point that you can feel confident
about writing good SQL and PL/SQL code, and knowing how to configure =
Oracle
database servers properly.
In many cases, however, queries run poorly because of the way they are
written. Perhaps you could send me a copy of your query (not through =
the
listserv given the reaction you got from Lee) and maybe I can point out =
a
few things you can try to improve your query's performance.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin & Operations | Admin. et Exploit. des syst=E8mes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique=20 Maritimes Region, DFO | R=E9gion des Maritimes, MPO
E-Mail: boivinp_at_mar.dfo-mpo.gc.ca <mailto:boivinp_at_mar.dfo-mpo.gc.ca>=20
-----Original Message----- From: lerobe - Lee Robertson [SMTP:LEROBE_at_acxiom.co.uk] Sent: Tuesday, November 07, 2000 12:36 PM 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/200002:55:22 AM
Please respond to ORACLE-L_at_fatcity.com =20 =20 =20DELETE
=20
=20
=20
To: Multiple recipients of list ORACLE-L =20 <ORACLE-L_at_fatcity.com> =20
=20
cc: (bcc: Marcos Vera/M&S Consultores/51) =20
=20
=20
=20
Subject: Re: Query to select only the duplicate records from=20 a table? =20
=20
SELECT interested_columns FROM table_name a WHERE rowid >(SELECT min(rowid) FROM table_name b WHERE b.pk_column =3D 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
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 (likesubscribing).
-- 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). --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20 Author:=20 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=20 of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. =20 If you have received this communication in error, please=20 re-send this communication to the sender and delete the=20 original message or any copy of it from your computer system. --=20 Please see the official ORACLE-L FAQ: http://www.orafaq.com --=20 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 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).--=20
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 Received on Tue Nov 07 2000 - 13:06:51 CST
 |
 |