var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: IQ Table Size increaing after the backup when compare with original table....
While Taking the table backup , my backup table size is 1.6 times of the original table.
Tested Backup using ,
Select * into Table_B from Table_A
Select * into Table_B from Table_A where 1=2 & then inserting the data...
If Table A is 30 GB ,
then Table_B is 48 GB.
Couldn't traceout the reason why it is happening....
Anyone out there pls suggest
Any Sybase IQ experts there ? Pls suggest .....
Got support from sybase ...
After a long research , we did rebuilding of indexes with distinct values for the Individual tables and experienced a drastic reduce in size....
Tags for this Thread