Hinting to Redshift how to distribute a join?
You cannot use hints in Redshift like Oracle. You can do things like set the distribution keys. If X is always used in that fashion, it may make sense to incorporate that into your DDL.  

See here:
http://docs.aws.amazon.com/redshift/latest/dg/t_Distributing_data.html