Sheen_Martin
Active Member
I have searched and read a lot of related posts on F0911 and performance issues. Most of them are AS/400 and Oracle databases, and I am not gaining any insight.
We have a custom report, for inventory component pricing. It selects on our 13 million F0911 records at first. After it prints the detail or summary section, it goes out and does more 'select' and 'fetch next' to get cost variance numbers, again from the F0911.
Now that the report is in production, it takes hours to run.
If I add an index specifically for this report, will I see a performance gain? The other options being bantered around involve changing the business view, which means report re-write.
Input is greatly appreciated.
We have a custom report, for inventory component pricing. It selects on our 13 million F0911 records at first. After it prints the detail or summary section, it goes out and does more 'select' and 'fetch next' to get cost variance numbers, again from the F0911.
Now that the report is in production, it takes hours to run.
If I add an index specifically for this report, will I see a performance gain? The other options being bantered around involve changing the business view, which means report re-write.
Input is greatly appreciated.