SQL tuning is more like a mindset of making the query perform better and at most of the time this requires rewriting the query in a better way that doesn't consume the engine performance.