Applying functions such as SUBSTR(), TRIM(), COALESCE(), CASE statements, and even the LIKE function to join columns can hinder the optimizer's ability to use existing statistics. Consequently, the optimizer must estimate the number of rows based on heuristics, which may result in inefficient query execution.