https://community.sap.com/t5/application-development-and-automation-discussions/selecting-from-fmioi-performance-question/m-p/2682358#M620128 <HTML><HEAD></HEAD><BODY><P>When I select from FMIOI using one fund (FONDS) and one fund center (FISTL) (let's call it fund center 1), I get results very quickly (within seconds). If I use the same fund and a different fund center (let's call it fund center 2), I still get results back quickly. But if I use the same fund as above and both fund centers 1 and 2 as selection criteria, it takes a long time to get results back. I see this behavior in both my custom program and when using SE16. Can anyone explain why selecting from FMIOI with two fund centers causes such a performance problem when individually the fund centers return with no problem?</P></BODY></HTML> Mon, 20 Aug 2007 19:30:34 GMT Former Member 2007-08-20T19:30:34Z https://community.sap.com/t5/application-development-and-automation-discussions/selecting-from-fmioi-performance-question/m-p/2682358#M620128 <HTML><HEAD></HEAD><BODY><P>When I select from FMIOI using one fund (FONDS) and one fund center (FISTL) (let's call it fund center 1), I get results very quickly (within seconds). If I use the same fund and a different fund center (let's call it fund center 2), I still get results back quickly. But if I use the same fund as above and both fund centers 1 and 2 as selection criteria, it takes a long time to get results back. I see this behavior in both my custom program and when using SE16. Can anyone explain why selecting from FMIOI with two fund centers causes such a performance problem when individually the fund centers return with no problem?</P></BODY></HTML> Mon, 20 Aug 2007 19:30:34 GMT https://community.sap.com/t5/application-development-and-automation-discussions/selecting-from-fmioi-performance-question/m-p/2682358#M620128 Former Member 2007-08-20T19:30:34Z https://community.sap.com/t5/application-development-and-automation-discussions/selecting-from-fmioi-performance-question/m-p/2682359#M620129 <HTML><HEAD></HEAD><BODY><P>I can't prove it, but my best guess is that the database optimizer gets confused. And unfortunately it doesn't take much either as you have seen yourself. I have seen the same behaviour with other tables, where selection_time(1) + selection_time(2) &lt;&lt; selection_time(1+2).</P><P></P><P>The database could perform one selection, then the next one, take a coffee break, and still return results much quicker than it does when selecting for both criteria.</P></BODY></HTML> Tue, 21 Aug 2007 12:02:08 GMT https://community.sap.com/t5/application-development-and-automation-discussions/selecting-from-fmioi-performance-question/m-p/2682359#M620129 KjetilKilhavn 2007-08-21T12:02:08Z