Forgive me but I am not following.
Are you saying that all those columns in the tables were converted
from number to varchar2 and I/O decreased,
or since the columns were number, you skipped converting them to
varchar2 and that's what gave you better performance?
While the second would make more sense to me, I have seen stranger
things...
Thank you for your time.
> I dealt with a situation where number(10) was converted to
> varchar2(10) left padded with zeroes.
> When I set up a pilot wit the correct datatype the I/O was *50*
> percent lower.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
Received on Fri Jun 08 2007 - 19:02:30 CDT
