| Bitmap & Normal Index for same column - Oracle [message #418604] |
Mon, 17 August 2009 11:16  |
nocturnal
Messages: 1
Registered: August 2009
|
Junior Member |
|
|
Hello,
Is it possible to create 2 indexes 1 Bitmap & 1 Normal for same column in Oracle table.
Table is a part of oracle data warehouse and Bitmaps will be disabled during data loading. if i build a normal index on one of the column this will improve my join conditions and job should take less time to complete. This index can be then disable before rebuilding Bitmap on same column.
Please guide as i haven't tried this before.
|
|
|
|
|
|
| Re: Bitmap & Normal Index for same column - Oracle [message #418630 is a reply to message #418605] |
Mon, 17 August 2009 22:00  |
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
|
Senior Member |
|
|
Are users using the table whilst you are loading? If so, then you need to find another way to load large volumes of data without impacting users. One such way might be to load a copy of the table and then use synonyms to redirect users to the new table when it is loaded.
If you just want to use the index whilst loading, you need to reevaluate your load. You shouldn't need to use an index to load data - except possibly the PK. If you need the index to load the table then you are probably doing something wrong.
Ross Leishman
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
