Re: Number Size on NT

From: Stephen Ferracioli <stephen.ferracioli_at_ingrammicr.com>
Date: 1998/01/07
Message-ID: <690ni5$3k2$1@usenet45.supernews.com>#1/1

Where you take the hit is on indexes.
Be careful in using NUMBER datatypes in indexes. They always take reserve 22 bytes in indexes. That's why it's possible for indexes to be larger than tables.

Josh Blatt wrote in message <68u1f9$l1v$1_at_news.fas.harvard.edu>...
>We have several tables where some number fields are set to way too high.
>I'm wondering how much I should worry about sizing them precisely. How
does
>Oracle store these? Is there a performance hit to having variables too
>large? If so, and where are the break points?
>
>Thanks much,
>
>Josh
>jblatt_at_harvard.edu
>
>
Received on Wed Jan 07 1998 - 00:00:00 CST