Re: Off Topic: SQL-Tuning guide for developers

Hi Volker...
You can refer to

1. Optimising SQL by Peter Gulutzan and Trudy Pelzer.... It talks about optimising Rules of Thumb...some 17 rules....
2. Advanced Oracle tuning and administration By Eyal Aronoff et.al. by Oracle press...Explain plan and Hints....
3. Oracle SQL High- Performance Tuning, Guy Harrison
   (Prentice-Hall,1997)(best of all)
   

Hope it helps.

Thanks
Vidya

From: Schoen Volker <v.schoen_at_inplan.de> Reply-To: ORACLE-L_at_fatcity.com
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Subject: Off Topic: SQL-Tuning guide for developers Date: Tue, 06 Jun 2000 05:17:06 -0800

Hi all,

I have the wonderful task to write down the guidelines for optimal use of SQL from point of performance criterea. I think this is written down sometimes before, so I don't want to invent the wheel new.

My question:
Is there a internet-link or some kind of documentation (Oracle documentation I have browsed) how to use SQL from the point of performance, something like "never use..., better use...".

Any information is appreciated.

TIA Volker Schön
E-Mail: mailto:v.schoen_at_inplan.de
http://www.inplan.de

--
Author: Schoen Volker
   INET: v.schoen_at_inplan.de

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