Rebuild index with online, parallel or nologging option

Rebuild index with Parallel option

---For Fast Index rebuild use Parallel option with nologging
alter index TEST_INDEX rebuild online parallel 8 nologging;

--For only parallel option
alter index TEST_INDEX rebuild online parallel 8;

--For rebuild offline
alter index TEST_INDEX rebuild parallel 8;


-- For index rebuild noparallel option
alter index TEST_INDEX rebuild noparallel;

Rebuild index with Logging or nologging option (default logging is enabled)

--For nologging option
alter index TEST_INDEX rebuild nologging;

--For logging option
alter index TEST_INDEX rebuild logging;
alter index TEST_INDEX rebuild;

Rebuild index online or offline ( default offline)

-- Index rebuild online
alter index TEST_INDEX rebuild online ; 

--index rebuild offline
alter index TEST_INDES rebuild;