Filtering data: Query method

Applies to: Apollo VCL™

If you do not have an index available you should use TApolloTable.Query instead of TApolloTable's SetFilter. method. Or, if you have an index use SetScope instead.

The Query method attempts to optimize the query (i.e. filter condition) using available indexes if possible. If it is unable to use an index, the Query method will treat the query string as a normal filter, just like SetFilter.

The only use for SetFilter is if you wanted to specifically issue a non-optimized filter (i.e. perhaps for your own speed comparisons). Also, Apollo supports SetRange which maps internally to SetScope.