Database DataWarehousing (MOSC)

MOSC Banner

Creating a local bitmap index

edited Oct 28, 2013 9:44PM in Database DataWarehousing (MOSC) 4 commentsAnswered
Hi,
   I need to create both local bitmap indexes and local btree indexes on various large range-partitioned tables in my database and, to reduce the time taken, I create each index in parallel. I find that I can get the creation of a btree index to use more than 1 parallel slave per partition but for some reason I cannot get the creation of a bitmap index to do the same - the best I can achieve is 1 slave per partition. Am I doing something wrong, or is this merely a restriction?

   Any thoughts would be very welcome.

Thanks and regards,  Andrew.

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