RE: Large databases

>
> Question to all you practical DBA's out there: Is is slower or faster
> to normalize or not?

>From an Oracle tuning book (I don't recall the title, but it was from Oracle
Press):

"Store the data the way you intend to query the data."

(I might add: "if possible")

There was also a quote, the gist of which (I don't recall it exactly), was something like: No large, fully normalized database can perform worth diddly.

(Maybe a little extreme, but probably as a reaction to those who insist that all databases MUST be fully normalized.)

I don't debate this kind of stuff, since it is religion. But, if you are counting votes, I tend to agree.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephen Lee
  INET: Stephen.Lee_at_DTAG.Com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).