Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2013
    Location
    Bangalore
    Posts
    30
    Provided Answers: 2

    Unanswered: IQ Table Size increaing after the backup when compare with original table....

    Hi ,

    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
    Yuvaraj Subramani

  2. #2
    Join Date
    Nov 2013
    Location
    Bangalore
    Posts
    30
    Provided Answers: 2
    Any Sybase IQ experts there ? Pls suggest .....
    Yuvaraj Subramani

  3. #3
    Join Date
    Nov 2013
    Location
    Bangalore
    Posts
    30
    Provided Answers: 2
    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....
    Yuvaraj Subramani

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •