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.