Row Migration and chaining
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?
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.
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
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.
Click Here to Expand Forum to Full Width