SQL Filter

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
jgabuardi
Posts: 13
Joined: Tue Oct 10, 2017 12:44 pm

SQL Filter

Post by jgabuardi » Sat Mar 14, 2009 12:56 pm

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

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> RE: SQL Filter

Post by kfleming » Tue Mar 17, 2009 8:02 am

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

Post Reply