Sesky
asked on
Modify column type using least space
Have a sybase table that occupies 40GB of size. 30GB of this space is occupied by one column which is defined as type "Text". As the table has 15million rows and each text field value is reserved 2KB of space, this seems right. The issue now is that there is only 5GB of space avaialble and this text field is not required.
Is there a way to drop / modify this filed type alone and save the 30GB of space given that there is only 5GB available? The table also have a couple of other indexes which about about 0.5 GB each. It has been suggested that we need another 40GB of space for any alter / modify operation on the original table that occupies 40GB. Is this true.
Is there a way to drop / modify this filed type alone and save the 30GB of space given that there is only 5GB available? The table also have a couple of other indexes which about about 0.5 GB each. It has been suggested that we need another 40GB of space for any alter / modify operation on the original table that occupies 40GB. Is this true.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
>> It has been suggested that we need another 40GB of space for any alter / modify operation on the original table that occupies 40GB. Is this true.
Yes, No other go in this scenario..
To do what I mentioned you need atleast 10GB more than what you have currently..
Yes, No other go in this scenario..
To do what I mentioned you need atleast 10GB more than what you have currently..
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Agreed. Thank you for all your comments.
ASKER