Andres_Ortega
Member
I added a custom index to our F0911 table to be used by a custom UBE that we created. I used OMW to create and promote the Index. The UBE without the index would take about 10 hours and with the index it takes about 5 minutes. The UBE is run about once a month by our finance group.
The problem is that when the UBE hasn't been run for for a couple of weeks when they run it, it doesn't use the index. To fix it we go into oracle and change the optimizer back and forth from CHOOSE to ALL_ROWS, and then back to CHOOSE while the UBE is running. After we do this the UBE starts flying again.
We have tried analyizing the database, recreating the indexes, etc.. However the only thing that seems to get the UBE going is changing the Optimizer settings.
Has anyone seen this before?
Thanks in advance for your help.
Andres Ortega
E1 8.10 XU1, Oracle 10g, on Intel/NT
The problem is that when the UBE hasn't been run for for a couple of weeks when they run it, it doesn't use the index. To fix it we go into oracle and change the optimizer back and forth from CHOOSE to ALL_ROWS, and then back to CHOOSE while the UBE is running. After we do this the UBE starts flying again.
We have tried analyizing the database, recreating the indexes, etc.. However the only thing that seems to get the UBE going is changing the Optimizer settings.
Has anyone seen this before?
Thanks in advance for your help.
Andres Ortega
E1 8.10 XU1, Oracle 10g, on Intel/NT