We are having some issues with performance in the query, and i wanted to tune it. We are using mode “timestamp”. So reading through the documentation it states:
Different query modes may still be used for incremental updates, but in order to properly construct the incremental query, it must be possible to append a WHERE clause to this query (i.e. no WHERE clauses may be used). If you use a WHERE clause, it must handle incremental queries itself.
I really don’t get what does it exactly mean with “If you use a WHERE clause, it must handle incremental queries itself” so shall i write the full query? Is there some placeholder i shall use for timestamp?
Just for sake of sample (our query is way more complex), if I would like so set a query like:
select * from myTable where date_1 between %1 and %2 or date_2 between %1 and %2
Would something like that be a possibility? So i would like the connector to just provide the timestamps, nothing else. Is something like that supported?
IMHO that would also help avoiding things like:
select * from ( another query ) where COALESCE(field1, field2)
Maybe i’m missing something?