Database Administration (MOSC)

MOSC Banner

Bitmap Index for marking and unmarking

edited May 4, 2010 9:33PM in Database Administration (MOSC) 7 commentsAnswered
Hello

-

I'm running on a 10.2.0.4 DB, and I have a table with a column which is use for marking and unmarking records.

Table has around twelve millions of rows, column has at most three distinct values (including nulls) and constantly is performed masive updates on this column for specific processes.

-

My question is: is it recommendable to use a bitmap index for that column?

-

Regards.

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