I have a table whose rowsize is nearing 4005 bytes and I want to
increase the length of one column. I know I have two ways to do this.
I can either increase the tablespace pagesize from 4K to 8K, or change
the column from being a varchar to longvarchar. Which is
better(performance wise)?
Also is it true that you cannot change the page sizes of tablespaces
on-the-fly -- you will have to export your data, drop all objects that
exist in the
tablespace, create new tablespaces with a larger page size, recreate
all
objects in the new tablespace, and the import your data.
Thanks in advance.