sql, opt: avoid full scans in mutation queries with cost flags

sql, opt: avoid full scans in mutation queries with cost flags #33809