>Hi.
>I have a Data Warehouse type application which uses very large files with lots of fields (Typically 130 fields in each table)
>
>These have always been set up as N(13,2), and they take up a lot of space
>(If I zip them I can get 90 % reduction)
>
>I;m wondering if I use some of the other data types will they:
>1. Increase Processing speed
> (These are updated regulalrly)
>2. Reduce the size of the tables
>
>Regards,
>
>Gerard

What about to change the type from Numeric to Currency? Currency type uses 8 bytes and in it can be stored values from -$922337203685477.5807 to $922337203685477.5807.