[单选]
In your test database， you have created the ORDERS table as an indexorganized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.
While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）

A . export and import the mapping table
B . drop and recreate the mapping table
C . truncate the mapping table and reinsert the values
D . use the ALTER TABLE .. REBUILD command to defragment the mapping table

不正当竞争行为是指违反法律规定和（）的、损害其他经营者的行为。市场竞争。竞争原则。竞争法则。行政法规。王威《走进心灵，师爱无痕》提出：正确看待心理发展过程中出现的种种（），使同学们切身感受教师的尊重、理解和信任。蛋白质缺乏将引起酶蛋白合成减少及酶活性降低，使毒物代谢减慢，机体对多数毒物的解毒能力降低，毒物毒性增加。生产流程改进的方法有（）。取消。合并。完善。重组。简化。人工费、材料费及机械台班费属于工程造价中的（）间接费。措施费。税费。直接费。

In your test database， you have created the ORDERS table as an indexorganized table （IOT）. To facilitate faster querying， you have created a mapping table and a bitmap index on the ORDER_FILLED column. You observe that the query performance degrades when users perform a large volume of transactions.
While investigating the reason， you find that the mapping table segment is fragmented， leading to poor performance. Which option would you use to defragment the mapping table without affecting the original table data？（）

参考答案：

● 参考解析

本题暂无解析

当前位置：1z0-043题库

相关题目: