Database DataWarehousing (MOSC)

MOSC Banner

BITMAP index creation taking long time

in Database DataWarehousing (MOSC) 17 commentsAnswered

Hi All,

Our BI team has issue with LOADs. loads are taking more time as "create index" part is taking more time. below are the tables where index creations are taking more time. as part of load indexes are dropped and recreated at the end. could you please suggest to speed up index creation process in LOADS.


WC_OE_BBB_A

WC_SPEND_A

W_GL_OTHER_F

Regards,

Raju

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center