An index-organized table (IOT) called SPARSE has had many records deleted. Which command reorganizes the IOT so that the empty space is removed, while minimizing the impact for users?()
- A、EXPORT with TABLES and IMPORT with the INDEX and IGNORE options.
- B、ALTER TABLE … COALESCE ;
- C、ALTER INDEX …REBUILD ONLINE;
- D、CREATE TABLE …AS SELECT_ONLINE;
正确答案:B
答案解析:有

微信扫一扫手机做题