Creation time of a bitmap index?
Hi,
11.2.0.2
A developer complained that her bitmap index creation has taken over two hours.
The table itself is partitioned and consists of over 150 million rows. Not much else going on in the DB.
CREATE BITMAP INDEX dw.TEST_INDEX
ON dw.TEST_TABLE (R_KEY)
LOCAL
LOGGING
TABLESPACE MARIDX
COMPUTE STATISTICS
There are over 13 000 distinct values for R_KEY
The current wait is;: library cache lock - which have been the current one for the last 30 minutes.
As I have never created a bitmap index my self, what is expected? I gathered statistics on the table after the complaint, it lacked stats.
11.2.0.2
A developer complained that her bitmap index creation has taken over two hours.
The table itself is partitioned and consists of over 150 million rows. Not much else going on in the DB.
CREATE BITMAP INDEX dw.TEST_INDEX
ON dw.TEST_TABLE (R_KEY)
LOCAL
LOGGING
TABLESPACE MARIDX
COMPUTE STATISTICS
There are over 13 000 distinct values for R_KEY
The current wait is;: library cache lock - which have been the current one for the last 30 minutes.
As I have never created a bitmap index my self, what is expected? I gathered statistics on the table after the complaint, it lacked stats.
0