Page 1 of 1

SQL Filter

Posted: Sat Mar 14, 2009 12:56 pm
by jgabuardi
Just for performance I want to know if "filter" is used as a part of the SQL query or applied to the composite record in the result set?____Regards____Jorge

=> RE: SQL Filter

Posted: Tue Mar 17, 2009 8:02 am
by kfleming
You can use Database Show SQL to see if the filter condition is being sent as part of the SELECT.__As long as the filter condition can be evaluated by the server it should be part of the WHERE clause in the SELECT.____Kathleen__R&R Support