Highly unlikely

Post #150,358 by ben_tilly 4/6/04 10:14:19 PM Reply	Highly unlikely A couple of decodes is highly unlikely to be a problem. However decode does take extra CPU. If that is a bottleneck, then you might want to think about it. When a system is heavily loaded, then anything could be the straw that breaks the camel's back. However scanning through large decodes can get very slow. If your decodes get to be very long lists, then sometimes you can benefit from finding a different strategy. If you wish to educate your well-meaning co-worker about how to address performance problems with Oracle, I can highly recommend [link\|http://www.amazon.com/exec/obidos/tg/detail/-/0072230657/104-4462303-5667164?v=glance\|Effective Oracle by Design]. Tom Kyte does a lot to explain what a helpful mindset is, and also to point you at what likely problem areas really are. Cheers, Ben To deny the indirect purchaser, who in this case is the ultimate purchaser, the right to seek relief from unlawful conduct, would essentially remove the word consumer from the Consumer Protection Act - [link\|http://www.techworld.com/opsys/news/index.cfm?NewsID=1246&Page=1&pagePos=20\|Nebraska Supreme Court]
Post #150,362 by Meerkat 4/6/04 10:28:33 PM Reply	Sounds like a great book We have Kyte's 'Export one-on-one' book lying around, sounds like this other one will soon be joining the collection. The other reason why I believe removing the Decode won't help all that much is because it'll just be shifted out of SQL and into program code. The decodes in question aren't long lists, just three options, affecting four fields. Will be able to do the experiment in about two hours from now (waiting for production stuff to finish to I can run tests. Yes, dev test & prod on the same box. No, not my decision :-) John. Busy lad.
Post #150,448 by kelzer 4/7/04 6:11:50 PM Reply	Re: Sounds like a great book Yeah, 'Export one-on-one' was a great follow up to 'Import one-on-one'. Both belong in the library of anyone involved in international trade. :)
Post #150,450 by Another Scott 4/7/04 6:16:56 PM Reply	Heh. We've got a comedian among us. :-) Cheers, Scott.
Post #150,483 by Meerkat 4/7/04 11:57:45 PM 4/7/04 11:59:02 PM Reply	My subconscious inadvertantly told you all what I spent most of time doing on Oracle that day. D'oh! And to make this (just slighlty) relevant - anyone else had mystery Ora-600 errors when trying to export tables created with 'create table compress...' ? (No, still haven't done the 'prove decode doesn't slow things down much' experiment. Real Work takes priority, for some silly reason) John. Busy lad. Edited by Meerkat April 7, 2004, 11:59:02 PM EDT Expand All History

Welcome to IWETHEY!