The tide will take you towards the wind, effectively increasing the wind speed. Especially useful on marginal days, it allows you to practise safe in the knowledge that you are not going to end up miles downwind!
Wind blowing with the tide effectively decreases the wind speed. It also produces flatter water but with the added risk that you do have to keep sailing upwind to maintain your position.