## Creating indexes using UNRECOVERABLE option.

CREATE index __index__ on weekly_sales (__col1__, __col2__)
       TABLESPACE index_tspace
       STORAGE  (initial 50M next 100M pctincrease 0)
       PARALLEL (degree 8)
       UNRECOVERABLE ;

