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.




Reply With Quote