【oracle】oracledba8NOLOGGING

2015-01-22 21:22:44 · 作者: · 浏览: 2

You noticed that the index tablespace in your database requires a

recovery. However, instead of performing a media recovery, you decide

d to re-create the indexes in a new tablespace. Which two options wou

ld you use to reduce the time it takes to re-create the indexes? (Choose two.)

A. ONLINE

B. REVERSE

C. PARALLEL

D. COMPRESS

E. NOLOGGING

F. COMPUTE STATISTICS

Answer: C, E

?

你注意到你的数据库中的索引表空间要求恢复。然而,不执行介质恢复,你决定重新在一个新的表空间上创建索引。你将如何操作以减少需要重新创建索引的时间?(选择两个。)