What benefits does creating an index with NOLOGGING have?

1.	What benefits does creating an index with NOLOGGING have?
A.	Space is saved in the redo log files
B.	The time it takes to create the index is decreased
C.	Performance improves for parallel creation of large indexes
D.	All mentioned above
Answer» E.

Discussion

No Comment Found

Related MCQs

What should be done to use a function-based index?
While designing the database for one of your online transaction processing (OLTP) applications, you want to achieve the following:a) High availability of datab) Faster primary key access to the table datac) Compact storage for the tableWhich type of tables would you use to achieve these objectives?
Which of the following condition is true to create an index in your own schema?
In ALTER TABLE Mainte ce Operations for Table Partitions which mainte ce operation partition is used by range, hash, list, composite(range/hash), composite(range/list) from the following?
In the following example which method is used to partition the index-organized table, sales?CREATE TABLE sales(acct_no NUMBER(5),acct_name CHAR(30),amount_of_sale NUMBER(6),week_no INTEGER,sale_details VARCHAR2(1000),PRIMARY KEY (acct_no, acct_name, week_no))ORGANIZATION INDEXINCLUDING week_noOVERFLOWPARTITION BY HASH (week_no)PARTITIONS 16STORE IN (ts1, ts2, ts3, ts4)OVERFLOW STORE IN (ts3, ts6, ts9);
What benefits does creating an index with NOLOGGING have?
Which key have automatically indexes, but you might want to create an index on a foreign key?
What Enables you to quickly change storage and tablespace parameters without having to drop the original index?
Which partition forms of composite partitioning is well suited for historical data, but lets you further group the rows of data based on unordered or unrelated column values?
Which type of partition will be done for the following?1. Partition description identifying partition bounds.

What benefits does creating an index with NOLOGGING have?

Discussion

No Comment Found

Related MCQs

Reply to Comment