# UseIncrementalStatements

The `UseIncrementalStatements` parameter specifies whether to run queries that identify new/updated and deleted records.

- When `UseIncrementalStatements=False`, the connector performs a full synchronize every time the task runs, using the query specified by the SQL parameter.

- When `UseIncrementalStatements=True`, the connector only performs a full synchronize the first time the synchronize task runs:

  - The first synchronize cycle runs the query specified by the InitialStatement parameter. If this parameter is not set, the connector runs the query specified by AddedAndUpdatedStatement.
  - The following synchronize cycles run the query specified by AddedAndUpdatedStatement to retrieve added and updated documents, and the query specified by DeletedStatement to retrieve deleted documents.

Using incremental mode can be more efficient if the database has items stored by modified date, because the connector doesn't need to rescan the entire database.

Type: | Boolean
Default: | False
Required: | No
Configuration Section: | TaskName or FetchTasks
Example: | `UseIncrementalStatements=True`
See Also: | InitialStatement AddedAndUpdatedStatement DeletedStatement

_FT_HTML5_bannerTitle.htm