We are increasing the use of Web Services, thus more procedures. It is very common for us to join a web service to a relational table, however the procedure join is executed for every row. Is it possible to update the query engine to apply a filter on the parent table prior to the procedure join? This will drastically reduce the number of calls and improve performance.
-Chris