If snapshot.mode is set to initial_schema_only, a full table scan is not required, as with big table it can a take a lot of time and resources. A TOP (0) or TOP (1) should be added to the SELECT statement in order to return only 0 or 1 row.