When you can buy a 76GB disk for $555,
which is less than 1 cent per 1MB,
the time & effort to discuss this matter
exceeds any cost savings by reducing the
amount of disk storage.
"Eric D. Pierce" wrote:
>
> Don't know if you can control allocation of numbers, but have
> you considered just putting them in char? There are major
> downsides (converting), but perhaps you can live with them.
> A long time ago I think I remember someone saying that
> indexes on numbers are faster than char.
> regards,
> ep
>
> On 20 Oct 2000, at 12:40, Val_Gamerman/Victoria_Financi wrote:
>
> Date sent: Fri, 20 Oct 2000 12:40:56 -0800
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Send reply to: ORACLE-L_at_fatcity.com
>
> > In all the years that I have dealt with Oracle (both as a developer and a
> > DBA -- altogether 3 years) I never stopped to pay much attention to the
> > fact that when you define a field in a table as NUMERIC, no matter what
> > precision and scale you define for it, you are always going to get 22 bytes
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Eric D. Pierce
> INET: PierceED_at_csus.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> 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).
--
Charlie Mengler Maintenance Warehouse
charliem_at_mwh.com 10641 Scripps Summit Ct
858-831-2229 San Diego, CA 92131
Your call is important to us. Please continue to hold!
Received on Fri Oct 20 2000 - 16:41:16 CDT
