Hi,
Cristina M writes:
> For each varchar column - I add an extra 4 bytes
>
>
> For each numeric column - I add an extra 8 bytes
>
On Wed, May 13, 2009 at 6:08 AM, Cristina M wrote:
> Hello,
> I posted to the general list, and didn't receive any replies. Therefore, I
> am trying this list now, hopefully this is the right mailing list for this
> type of questions.
> I am trying to compute the no of pages of a table. I am using
Cristina M wrote:
> I posted to the general list, and didn't receive any replies.
> Therefore, I am trying this list now, hopefully this is the right
> mailing list for this type of questions.
>
> I am trying to compute the no of pages of a table. I am using the formula :
>
> pages = ( columns w
Cristina M escreveu:
> - for table t2(l_orderkey int, l_partkey int, l_quantiy, l_tax,
> l_extendedprice, l_discount) I got an error of 42 %.
>
I suspect you have NULLs in your table; they're stored as bitmaps, so they use
little space.
--
Euler Taveira de Oliveira
http://www.timbira.com/
Hello,
I posted to the general list, and didn't receive any replies. Therefore, I am
trying this list now, hopefully this is the right mailing list for this type of
questions.
I am trying to compute the no of pages of a table. I am using the formula :
pages = ( columns width + 28) * no. o