SQL Performance (MOSC)

MOSC Banner

Partitioned Bitmap Index on a very large Data Warehouse partioned fact table.

edited Mar 4, 2016 10:12AM in SQL Performance (MOSC) 2 commentsAnswered ✓

We have a Bitmap index on a fieldA , very large range partitioned/month  fact table. When the user issues a query without a range specified, it

results in a full table scan even though a single value for field A is mentioned. the bitmap index does not get used?

any thoughts why ? Is it because the bitmap index is a local index and not a global one ?

thanks for suggestions / answers.

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