| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Maximun number of unions in a single query
Andreas Sheriff wrote:
> Hey now,
> That's not nice.
Hey come on.. as a DBA you should know first hand of the problems caused by idiotic SQL statements in production. Like a SQL doing UNIONs of a bunch of tables.
> You don't even know what I'm using multiple unions for.
Multiple unions tells me you want to concat a bunch of different data sets into a single data set. That does not make sense. From presentation to background processing. It tells me that either the SQL writer is clueless, or worse, that the db designer failed to consider 3rd normal form. (and ignored Oracle Concepts like partitioning)
Lemme say it again. 3rd normal form ain't just a nice-to-have.
> Instead you jump to conclusions like the mendicant you are.
Dammit. Now I have to go and look up that word...
<minutes later>
men·di·cant Pronunciation (mnd-knt)
adj.
Depending on alms for a living; practicing begging.
n. 1. A beggar. 2. A member of an order of friars forbidden to own property in common,who work or beg for their living.
Hmm.. even with a cup of coffee I don't understand what you're implying. Besides, I appreciate being called an asshole more than in-between-the-lines insults. :-)
-- BillyReceived on Wed Jun 08 2005 - 02:37:25 CDT
 |
 |