only the offline providers support SQL Change Tracking. The SqlSyncProvider doesnt make use of this and is using it's own tracking mechanism via triggers and the _tracking table.
if there's any effect, it's the performance, since you now have two tracking mechanism for every change to the table.