At 03:23 PM 6/13/2001 +0100, Ray Drew wrote:

>
> I did not see in the docs that INT64 would vary its
>storage requirements.... Will an INT64 compress a value of
>32767 to 2 bytes? Or 255 to 1 byte?

No, I picked the best case. The whole record is subject to run length
compression. Any run of three or more identical bytes is compressed to
two bytes, length and value. Any run of more than 128 identical bytes
will require two length/value pairs.

> >The datatype of a numeric value has no effect on indexing.
>
>So there's no performance benefit in using smaller keys?

Not for numerics.

Regards,

Ann
www.ibphoenix.com
We have answers.