单项选择题
Asaresultofperformanceanalysis,youcreatedanindexontheprod_namecolumnoftheprod_dettable,whichcontainsabouttenthousandrows.Later,youupdatedaproductnameinthetable.Howdoesthischangeaffecttheindex?()
A.Aleafwillbemarkedasinvalid.
B.Anupdateinaleafrowtakesplace.
C.Theindexwillbeupdatedautomaticallyatcommit.
D.Aleafrowintheindexwillbedeletedandinserted.
E.Theindexbecomesinvalidwhenyoumakeanyupdates.