The procedure feature in Host Integrator is often associated with SQL, but you can also explicitly execute a procedure directly through the Host Integrator connector APIs using the PerformTableProcedure method. Doing so enables you to bypass procedure resolution and post-fetch filtering. Depending on the structure of your host application and whether you benefit from the additional capabilities provided by SQL, executing procedures directly might improve the performance of your deployed models.
The process for creating procedures is the same whether you execute the procedure using SQL or the PerformTableProcedure method.
See Accessing Host Data Using Host Integrator Connector APIs for information on using the PerformTableProcedure method.