which two situations would you rebuild an index using the ALTER INDEX—– REBUILD command?

In which two situations would you rebuild an index using the ALTER INDEX—– REBUILD
command?

In which two situations would you rebuild an index using the ALTER INDEX—– REBUILD
command?

A.
to change a unique index into a non-unique index

B.
to change index storage options

C.
to enable index monitoring

D.
to move the index to another tablespace

E.
to improve performance of an INDEX CLUSTER



Leave a Reply 0

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