Support runnning on an instance configured for SMB
support left join in preferred gap related keys