Re: Oracle Index Question

From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Thu, 04 Dec 2003 08:52:08 -0800
Message-ID: <1070556759.674361@yasure>

Guido Konsolke wrote:

> "Daniel Morgan" wrote...
> (snipped the little quote of the original posting ;-)
>

>>This still unnamed app looks like it was written for a mainframe or
>>worse and ported to Oracle without intervention of a single synapse.
>>
>>How else to explain those column names and data type definitions.

>
> This
>

>>is the poster child for of ugly.
>>-- 
>>Daniel Morgan
>>http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
>>http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
>>damorgan_at_x.washington.edu
>>(replace 'x' with a 'u' to reply)

>
>
> Hi Daniel,
>
> please allow one question out of curiosity: what's wrong with the
> column *names*? I can't figure it out.
>
> Enlightenment appreciated.
>
> Greetings,
> Guido

They have no meaning. The ability to select the wrong column or to join on the wrong columns is extremely high. It is a design typical of someone throwing columns at a problem and deciding to figure out later what they'd be used for.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)

Received on Thu Dec 04 2003 - 10:52:08 CST