Indexes created using NOLOGGING are not archived - Perform a backup - Oracle Indexes and Partitioned Tables

Q.  Because indexes created using NOLOGGING are not archived, perform a backup after you create the index.
- Published on 12 Aug 15

a. True
b. False

ANSWER: True
 

    Discussion

  • Nirja Shah   -Posted on 28 Sep 15
    - 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.)