As a result of performance analysis, you created an index on the prod_name column of the prod_det table, which contains about ten thousand rows. Later, you updated a product name in the table. How does this change affect the index?()
- A、A leaf will be marked as invalid.
- B、An update in a leaf row takes place.
- C、The index will be updated automatically at commit.
- D、A leaf row in the index will be deleted and inserted.
- E、The index becomes invalid when you make any updates.
正确答案:D
答案解析:有
微信扫一扫手机做题