Main advantage is that it does not actually run the query - just parses the SQL. In the early stages of tuning explain plan gives you an idea of the potential performance of your query without actually running it.