sandhya

• Jun 27th, 2005

 

if any of he empty row is not sufficient to hold the row. then row is placed in multiple blocks. it happenes when the block size is small and rows are of large size. then it cause chaining. Due to chaining performance degrades and will cause more IOs

deepikadba

 Profile Answers by deepikadba 

• Jun 6th, 2008

 

if a datablock is not able to store a complete row due to its less size then a row is store in another blocks & address of that row is stored in the previous block.it degrade performance of a database & there r more IOS generated.