RE: DWH varchar2(4000)

From: Jeff Smith <jeff.d.smith_at_oracle.com>
Date: Tue, 23 Dec 2014 09:33:23 -0800 (PST)
Message-ID: <20707f8a-32bb-4247-9934-5f082cf77116_at_default>

Hey Dave, if you make that into a bumper sticker, I'll buy a few dozen.

"Duhveloper: "We will never have over 1000000 rows" DBA: "Tell someone who cares. The field will be NUMBER(12,0)"

3 years later the table holds over 5 million rows."

-----Original Message-----

From: Dave Morgan [mailto:oracle_at_1001111.com] Sent: Tuesday, December 23, 2014 10:43 AM To: Oracle-L
Subject: RE: DWH varchar2(4000)

We only have 3 sizes of VARCHAR2 1, 255, and 2000 (soon to be 4000). Does not matter whether it is OLTP, hybrid or DW Doesn't Knuth have something to say about unnecessary optimization

My job is not to make the duhvelopers job easier, it is to make the lives of data entry clerks easier.

Limiting the size of VARCHAR2 fields causes production outages. The same way limiting the size of numeric fields does.

Duhveloper: "We will never have over 1000000 rows" DBA: "Tell someone who cares. The field will be NUMBER(12,0)"

3 years later the table holds over 5 million rows.

:)

YMMV
LF

--

Dave Morgan
Senior Consultant, 1001111 Alberta Limited dave.morgan_at_1001111.com 403 399 2442
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 23 2014 - 18:33:23 CET