You are creating a large index on the EMP table

You are creating a large index on the EMP table
This index will have a high number of inserts.To speed up creation of the index,what can be done?
A.Use the NOLOGGING clause in the CREATE INDEX command.
B.Use the same INITRANS value of the corresponding table on the index.
C.SET the DB_BLOCK_SIZE to multiples of 5.
D.Place indexes in separate tablespaces.
Karena_Tsang 1年前 已收到1个回答 举报

playshmily 幼苗

共回答了13个问题采纳率:100% 举报

这是英语阅读理解吧,不写出原文,找不出答案来的

1年前

3
可能相似的问题
Copyright © 2024 YULUCN.COM - 雨露学习互助 - 16 q. 0.051 s. - webmaster@yulucn.com