Does anyone now how if there is something in the rapidmart installation that populates the lookup_indexes table it creates or is this done manually?
Thanks
maverick976 
(BOB member since 2004-07-06)
In Oracle, there is no method to disable an index (without sideeffects) and rebuild it later, so we drop all bitmap indexes and recreate them from scratch. But we need to remember the index settings somewhere - in this table.
Before each fact table there is a script calling a stored procedure. By default, this stored procedure does nothing but we provide you with a sample that, if installed, is using this table.
Again, it deals with BITMAP!!! indexes only.
http://www.consulting-accounting.com/time/servlet/ShowPage?COMPANYID=43&ELEMENTID=42
Werner Daehn 
(BOB member since 2004-12-17)
thank you for your answer. Since im on Oracle I should be able to use the sample stored procedure supplied with the RapidMart as is. However, this procedure references a table called lookup_indexes that is empty by default. The question is do I have to manually populate it or is there some automated script supplied with the rapidmart?
maverick976 (BOB member since 2004-07-06)
Whenever the post_processing stored procedure drops a bitmap index, it will insert the index parameters into that table.
Or short: No, you don’t have to do anything.
Werner Daehn (BOB member since 2004-12-17)