>>i am using free table for my application, may i check with anyone here, which syntax can produce a report faster, set filter ? or SQL ?
>
>As a table grows in size, using SET FILTER will become more and more unworkable. An optimized SQL statement, however, will produce better results.

Unless the filter returns a huge part of the table.

Vlad