Database DataWarehousing (MOSC)

MOSC Banner

invisible - Bitmap index

edited Feb 15, 2011 7:49AM in Database DataWarehousing (MOSC) 3 commentsAnswered
 RE: Oracle five node RAC version 10.2.0.4 on Linux
we have a partition table with 549 partitions and it has 10 indexes. how could we mimic invisible index operation in 10g? (I understand that 11g offers this function)

one of the option I thought.... drop one bitmap index and figure out how it effect the data load performance or report/SQL query, but then I will have rebuild this index and it will take long time to create again - very costly.

What are my other options?

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