invisible - Bitmap index
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?
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?
0