ODS-Activation problem

Question: Gurus
My ODS activation of M records is taking long time , is it wise to change any settings in SBIW or there any methods to do that .

Inputs please ???

Answer:
Gurus
My ODS activation of M records is taking long time , is it wise to change any settings in SBIW or there any methods to do that .

Inputs please ???

Hi

Due to a defect in the optimizer relating to the IDS OPTCOMPIND parameter setting of 2 used with BW, the IDS optimizer sometimes uses incorrect access plans. When you activate the ODS, this can greatly impair the performance. This is caused by accesses to the initially empty RSODSACTDATA table.

Might wanna look have these Note - 634569

Also read note 485061 for BW< 3.X

Hope it Helps
_________________
Chetan
@ CP...
Copyright ?2007 - 2008 www.jt77.com