Row Migration and chaining
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Row Migration and chaining

  1. #1
    Join Date
    Aug 2003
    Posts
    5

    Row Migration and chaining

    Hi All,

    I have two tables which have have two columns whose datatype is of LONG and LONG RAW.I always see that there are chained rows in these tables.Is there any way to remove the chained rows?

    TIA

    Mike

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Not realy. If the values in those LONG and LONG RAW columns are bigger than your database block size, then there is no way to avoid row chaining.

    Your best option would be to change those columns to LOBS so that you can specify sepparate storage segments for them, thus avoiding excessive recursive I/Os for other columns in those tables when you don't need those LONG/LONGRAW columns.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,136
    If the DB contains more images or spatial data, then consider increase DB_BLOCK_SIZE. This option may not be a real solution if only a couple of tables have LONG columns.

Posting Permissions

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



Click Here to Expand Forum to Full Width