Caching frequent results can have a significant impact on Redshift performance. By storing the results of frequent queries in cache, Redshift can return the results of these queries much faster, reducing the time and resources required to execute these queries.