Which two options would you use to reduce the time it takes to re-create the indexes?

You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to re-create the indexes in a new tablespace.
Which two options would you use to reduce the time it takes to re-create the indexes? (Choose two.)

You noticed that the index tablespace in your database requires a recovery. However, instead of performing a media recovery, you decided to re-create the indexes in a new tablespace.
Which two options would 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



Leave a Reply 0

Your email address will not be published. Required fields are marked *