Xref: alice comp.databases.oracle.server:43591 Path: alice!news-feed.fnsi.net!newsfeed1.earthlink.net!newsfeed.berkeley.edu!news2.best.com!news1.best.com!sdd.hp.com!hp-corv.cv.hp.com!news.vcd.hp.com!not-for-mail From: bjin Newsgroups: comp.databases.oracle.server Subject: Re: Long Integers and Oracle Numbers Date: Fri, 19 Mar 1999 17:52:55 +0800 Organization: Hewlett Packard Lines: 44 Message-ID: <36F21E77.7F3E8246@hpsgns1.sgp.hp.com> References: <7cr94r$qri$1@nnrp1.dejanews.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Trace: wwproxy.vcd.hp.com 921837250 14334 15.68.50.133 (19 Mar 1999 09:54:10 GMT) X-Complaints-To: news@news.vcd.hp.com NNTP-Posting-Date: 19 Mar 1999 09:54:10 GMT X-Mailer: Mozilla 4.05 [en] (X11; I; HP-UX B.10.20 9000/777) Hi darren, Documentation is right. Number(10) can't provide better performance than number(38). Rather it's a ristriction on the column. As for internal format, for example, number 1234 will be store in a format like 1.234x10^3. You can refer Oracle server concepts for detail info. Hth bjin darren_reynolds1118@my-dejanews.com wrote: > I'm used to working with systems where you worry about the speed of > execution. If you have a field you know will only ever hold values 0-255, you > call it a Byte. 0-~2bn is a Long Integer. > > So along came Oracle 8, and I had to design a data model. All the > documentation says that for any integer, you should use Number(38). According > to the same documentation, this is allows for the storage of up to 38 digits, > with decimal point anywhere. Now, I know that this will probably work, but it > doesn't sound like a terribly optimal way of going about storing a 32-bit > Long Integer. > > Does anyone know anything about how Oracle handles Number fields internally? > Is there anything to be gained by using, say Number(10) over Number(38), and > ignoring the documentation? > > Thanks in advance! > > Darren Reynolds, > Halifax plc, England > > -----------== Posted via Deja News, The Discussion Network ==---------- > http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own