if your update statement includes a column on which there exsists an index , then apart from updating the Table segment the corresponding index segments are also updated, this might lead to total or partial restructuring of the index....hence increasing indexes might adversely affect updation.




Reply With Quote