RE: Off Topic: SQL-Tuning guide for developers

--openmail-part-09459cb8-00000001

Content-Type: text/plain; charset=US-ASCII; name="BDY.TXT"
Content-Disposition: inline; filename="BDY.TXT"
Content-Transfer-Encoding: 7bit

> 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...".

Volker,

IMHO, Guy Harrison's 'SQL Tuning' book is probably one of the best. My advice - get it!

John Kanagaraj
Brunei Shell Petroleum
http://www.geocities.com/john_sharmila

God so loved the world that He didn't send a committee! (See John 3:16 for details)
** Opinions expressed here are solely mine and not necessarily those of my employer **

--openmail-part-09459cb8-00000001

Content-Type: application/ms-tnef; name="WINMAIL.DAT"
Content-Disposition: attachment; filename="WINMAIL.DAT"
Content-Transfer-Encoding: base64

eJ8+IkwQAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5N aWNyb3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEDkAYADAAAAAEAAAADABcAAQAA ABwAAQOQBgAMAAAAAQAAAAMANgAAAAAAOgABBIABAC8AAABSRTogT2ZmIFRvcGljOiBTUUwt VHVuaW5nIGd1aWRlIGZvciBkZXZlbG9wZXJzAAUQAQOQBgAMAAAAAQAAAAsAAgABAAAADwAB A5AGAAwAAAABAAAACwArAAAAAAA3AAEDkAYADAAAAAEAAAADAC4AAAAAADIAAQOQBgAUAAAA AQAAAAIBMQABAAAAAQAAAAAAAAA3AAEDkAYAEAAAAAEAAABAADkA4E2OijHQvwGABAEDkAYA JAAAAAEAAAAeAEIAAQAAABIAAABKb2huIEouIEthbmFnYXJhagAAADsGAQOQBgAQAAAAAQAA AEAASAAwvZaLMdC/AVgEAQOQBgA8AAAAAQAAAB4AcAABAAAAKwAAAE9mZiBUb3BpYzogU1FM LVR1bmluZyBndWlkZSBmb3IgZGV2ZWxvcGVycwAAzw8BA5AGACgAAAABAAAAAgFxAAEAAAAW AAAAAb/QMYp9GWA2ITwBEdSTUgBgl5kRswAAfwgBA5AGAAwAAAABAAAAAwAGEMQBMtbnAQED kAYADAAAAAEAAAADAAcQWQIAAHYAAQOQBgB4AAAAAQAAAB4ACBABAAAAZQAAAElIQVZFVEhF V09OREVSRlVMVEFTS1RPV1JJVEVET1dOVEhFR1VJREVMSU5FU0ZPUk9QVElNQUxVU0VPRlNR TEZST01QT0lOVE9GUEVSRk9STUFOQ0VDUklURVJFQUlUSElOS1QAAAAAYh4BA5AGAAwAAAAB AAAAAwAQEAEAAAAlAAEDkAYADAAAAAEAAAADABEQAAAAACUAAQOQBgAUAAAAAQAAAB4AQhAB AAAAAQAAAAAAAABzAAEDkAYAEAAAAAEAAABAAAcw4I8vGzHQvwHyAwEDkAYAEAAAAAEAAABA AAgw4I8vGzHQvwHzAwEDkAYAIAAAAAEAAAACAQswAQAAABAAAAAfNmAZATzUEZNSAGCXmRGz eQUBA5AGAAwAAAABAAAAAwDeP69vAAA/AgEDkAYAJAAAAAEAAAADAKiFCCAGAAAAAADAAAAA AAAARgAAAAAQhQAAAAAAAPoCAQOQBgAkAAAAAQAAAAMAqYUIIAYAAAAAAMAAAAAAAABGAAAA AAGFAAAAAAAA7AIBA5AGACQAAAABAAAAAwCqhQggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAA AAD9AgEDkAYAJAAAAAEAAAADAKuFCCAGAAAAAADAAAAAAAAARgAAAABShQAA4xUAADcEAQOQ BgAsAAAAAQAAAB4ArIUIIAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABAAAADguNQD9AwED kAYAJAAAAAEAAAALAK2FCCAGAAAAAADAAAAAAAAARgAAAAAGhQAAAAAAAP0CAQOQBgAkAAAA AQAAAAsAroUIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAABgMBA5AGACQAAAABAAAAAwCv hQggBgAAAAAAwAAAAAAAAEYAAAAAGIUAAAAAAAAJAwEDkAYALAAAAAEAAAAeALCFCCAGAAAA AADAAAAAAAAARgAAAAA2hQAAAQAAAAEAAAAAAAAARQMBA5AGACwAAAABAAAAHgCxhQggBgAA AAAAwAAAAAAAAEYAAAAAN4UAAAEAAAABAAAAAAAAAEcDAQOQBgAsAAAAAQAAAB4AsoUIIAYA AAAAAMAAAAAAAABGAAAAADiFAAABAAAAAQAAAAAAAABJAwEDkAYAJAAAAAEAAAALALOFCyAG AAAAAADAAAAAAAAARgAAAAAAiAAAAAAAAAMDAQOQBgAkAAAAAQAAAAsAtIULIAYAAAAAAMAA AAAAAABGAAAAAAWIAAAAAAAACQMBA5AGABgAAAABAAAAHgA9AAEAAAAFAAAAUkU6IAAAAABT AQEDkAYADAAAAAEAAAADAIAQ/////5AEAQkABAACAAAAAAAAAAEDkAYADAAAAAEAAAALACMA AAAAAC8AAQOQBgAMAAAAAQAAAAsAKQAAAAAANQABBJAGAIQFAAADAAAAEAAAAAMAADAEAAAA CwAPDgAAAAACAf8PAQAAAFoAAAAAAAAAjVVM0Ow8Ec6B/wgACbEDegEAAAALAAAAAAAAADEd b3JhY2xlZGJhHjUdbWltZR4xNh1IUE1FWFQxHjE3HW9yYWNsZWRiYUBxdWlja2RvYy5jby51 awAAAB4AAjABAAAACQAAAE9QRU5NQUlMAAAAAB4AAzABAAAAKwAAAG9yYWNsZWRiYSAvbWlt ZSAob3JhY2xlZGJhQHF1aWNrZG9jLmNvLnVrKQAAAwAVDAEAAAADAP4PBgAAAB4AATABAAAA CgAAAG9yYWNsZWRiYQAAAAIBCzABAAAANAAAAE9QRU5NQUlMOm9yYWNsZWRiYSAvbWltZSAo b3JhY2xlZGJhQHF1aWNrZG9jLmNvLnVrKQADAAA5AAAAAAsAQDoBAAAAHgD2XwEAAAAKAAAA b3JhY2xlZGJhAAAAAgH3XwEAAABaAAAAAAAAAI1VTNDsPBHOgf8IAAmxA3oBAAAACwAAAAAA AAAxHW9yYWNsZWRiYR41HW1pbWUeMTYdSFBNRVhUMR4xNx1vcmFjbGVkYmFAcXVpY2tkb2Mu Y28udWsAAAADAP1fAQAAAAMA/18AAAAAAgH2DwEAAAAEAAAAAAAABBAAAAADAAAwBQAAAAsA Dw4AAAAAAgH/DwEAAABVAAAAAAAAAI1VTNDsPBHOgf8IAAmxA3oBAAAACwAAAAAAAAAxHW9y YWNsZS1sHjUdbWltZR4xNh1IUE1FWFQxHjE3HW9yYWNsZS1sQGZhdGNpdHkuY29tAAAAAB4A AjABAAAACQAAAE9QRU5NQUlMAAAAAB4AAzABAAAAJgAAAG9yYWNsZS1sIC9taW1lIChvcmFj bGUtbEBmYXRjaXR5LmNvbSkAAAADABUMAQAAAAMA/g8GAAAAHgABMAEAAAAJAAAAb3JhY2xl LWwAAAAAAgELMAEAAAAvAAAAT1BFTk1BSUw6b3JhY2xlLWwgL21pbWUgKG9yYWNsZS1sQGZh dGNpdHkuY29tKQAAAwAAOQAAAAALAEA6AQAAAB4A9l8BAAAACQAAAG9yYWNsZS1sAAAAAAIB 918BAAAAVQAAAAAAAACNVUzQ7DwRzoH/CAAJsQN6AQAAAAsAAAAAAAAAMR1vcmFjbGUtbB41 HW1pbWUeMTYdSFBNRVhUMR4xNx1vcmFjbGUtbEBmYXRjaXR5LmNvbQAAAAADAP1fAQAAAAMA /18AAAAAAgH2DwEAAAAEAAAAAAAABRAAAAADAAAwBgAAAAsADw4AAAAAAgH/DwEAAABTAAAA AAAAAI1VTNDsPBHOgf8IAAmxA3oBAAAACwAAAAAAAAAxHXYuc2Nob2VuHjUdbWltZR4xNh1I UE1FWFQxHjE3HXYuc2Nob2VuQGlucGxhbi5kZQAAHgACMAEAAAAJAAAAT1BFTk1BSUwAAAAA HgADMAEAAAAkAAAAdi5zY2hvZW4gL21pbWUgKHYuc2Nob2VuQGlucGxhbi5kZSkAAwAVDAIA AAADAP4PBgAAAB4AATABAAAACQAAAHYuc2Nob2VuAAAAAAIBCzABAAAALQAAAE9QRU5NQUlM OnYuc2Nob2VuIC9taW1lICh2LnNjaG9lbkBpbnBsYW4uZGUpAAAAAAMAADkAAAAACwBAOgEA AAAeAPZfAQAAAAkAAAB2LnNjaG9lbgAAAAACAfdfAQAAAFMAAAAAAAAAjVVM0Ow8Ec6B/wgA CbEDegEAAAALAAAAAAAAADEddi5zY2hvZW4eNR1taW1lHjE2HUhQTUVYVDEeMTcddi5zY2hv ZW5AaW5wbGFuLmRlAAADAP1fAQAAAAMA/18AAAAAAgH2DwEAAAAEAAAAAAAABoon Received on Tue Jun 06 2000 - 22:36:21 CDT