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

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / My subconscious inadvertantly told you all
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.
Collapse Edited by Meerkat April 7, 2004, 11:59:02 PM EDT
Heh, 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.
Collapse 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

Tasty little nuggets of alien technology...
48 ms