IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Sounds like a great book
Post #150,362
by Meerkat
4/6/04 10:28:33 PM
Reply
New 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
New 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
New 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
New 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.
Expand Edited by Meerkat April 7, 2004, 11:59:02 PM EDT
Expand All History
     Oracle: 'DECODE' performance impact? - (Meerkat) - (19) - April 6, 2004, 09:47:12 PM EDT
         Highly unlikely - (ben_tilly) - (4) - April 6, 2004, 10:14:19 PM EDT
             Sounds like a great book - (Meerkat) - (3) - April 6, 2004, 10:28:33 PM EDT
                 Re: Sounds like a great book - (kelzer) - (2) - April 7, 2004, 06:11:50 PM EDT
                     Heh. We've got a comedian among us. - (Another Scott) - April 7, 2004, 06:16:56 PM EDT
                     My subconscious inadvertantly told you all - (Meerkat) - April 7, 2004, 11:59:02 PM EDT
         Depends on what clause - (ChrisR) - (3) - April 6, 2004, 10:52:32 PM EDT
             Just to clarify that - (ben_tilly) - (2) - April 7, 2004, 01:14:51 AM EDT
                 It's just in the SELECT clause - (Meerkat) - (1) - April 7, 2004, 02:02:20 AM EDT
                     Functions in the WHERE can be fine - (ben_tilly) - April 7, 2004, 10:57:43 AM EDT
         Belated answer: "What they said". - (CRConrad) - (8) - April 7, 2004, 09:50:49 AM EDT
             Transposing rows to columns is a PITA - (ben_tilly) - (7) - April 7, 2004, 10:50:12 AM EDT
                 "When the only tool you have is a hammer..." - (CRConrad) - (6) - April 8, 2004, 01:52:00 AM EDT
                     But that isn't the only tool that I have - (ben_tilly) - (5) - April 8, 2004, 02:23:07 AM EDT
                         At least Perl is a good hammer to have - (Meerkat) - (3) - April 8, 2004, 03:02:39 AM EDT
                             use that one a lot - (Steve Lowe) - (2) - April 8, 2004, 03:12:58 AM EDT
                                 I don't like it - (broomberg) - (1) - April 22, 2004, 10:58:47 PM EDT
                                     No feedback? That's what top / glance is for :) -NT - (Meerkat) - April 23, 2004, 02:23:05 AM EDT
                         No no no, you misunderstand! - (CRConrad) - April 8, 2004, 03:11:51 AM EDT
         Eliminate decode wherever you can - (tuberculosis) - April 9, 2004, 03:01:43 AM EDT

He's at the sack of hair level...and sinking rapidly.
71 ms