Decoding explain

<span>Even though the EXPLAIN plan is in plain English, it is not easy to understand the underlying meaning without understanding the main keywords. At first look, it possibly won't make any sense to you and you may not relate it to the query. We will decode the output into its pieces to carve out the relevant information behind it.