# 4752 SQL SELECT JOINOPTIMIZECOSTS Keyword Not Working Properly

---

The SQL SELECT JOINOPTIMIZECOSTS keyword does not work properly in most cases because it is using incorrect sampling of candidate values from the parent table involved in the join. This results in joins not using row scans in situations where they should be, such as cases where the amount of I/O involved in an index scan would be prohibitively large.