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.