we ran into issues with this a long time ago. not sure i completely remember the exact thing but it was something like when you use a filter for your main constraint the jump in and out logic doesnt seem to work properly and somehow ends up doing table scans

i think we ended up adding the same to the constraint to make it happy somehow

again not sure if this was exactly it but we had the same issue when trying to use sql filter to constrain the db to a tenant