Database DataWarehousing (MOSC)

MOSC Banner

Indexes running on Nologging and Parallel clause.

edited May 7, 2014 7:44AM in Database DataWarehousing (MOSC) 5 commentsAnswered

Hi,

Some Indexes are running with NoLogging and Parallel Clause option in big tables of our database.These indexes are running on the NoLogging and Parallel clause for the last 2 years.Is it advisable to keep the indexes on Nologging and Parallel clause.

Please explain the impact of keeping Indexes in NoLogging and Parallel Clause, if any.

Note - Can we recreate those indexes with Logging and NoParallel clause.

Thanks.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center