Creating index with NOLOGGING benefits - Oracle Indexes and Partitioned Tables

Q.  What benefits does creating an index with NOLOGGING have?
- Published on 30 Jul 15

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: All mentioned above

Related Content

 

    Discussion

  • Nirja Shah   -Posted on 28 Sep 15
    - You can create an index and generate minimal redo log records by specifying NOLOGGING in the CREATE INDEX statement.

    - Because indexes created using NOLOGGING are not archived, perform a backup after you create the index.

    - Creating an index with NOLOGGING has the following benefits:

    1. Space is saved in the redo log files.
    2. The time it takes to create the index is decreased.
    3. Performance improves for parallel creation of large indexes.

    - In general, the relative performance improvement is greater for larger indexes created without LOGGING than for smaller ones.

    - Creating small indexes without LOGGING has little effect on the time it takes to create an index.

    - However, for larger indexes the performance improvement can be significant, especially when you are also parallelizing the index creation.

➨ Post your comment / Share knowledge


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
▲