SQL Databases
-
You can push down record selection on indexed or non-indexed fields.
-
Your SQL server will respond faster if you use indexed fields.
-
You can push down AND and OR clauses.
-
Record selection formulas containing some types of embedded formulas can be pushed down.
-
You should incorporate SQL Expression fields to push down formula calculations necessary for the record selection.
-
On the Database menu, click Show SQL Query to view the SQL that will be sent to the database server.