Database Reference
In-Depth Information
your query,
explain
will show you if a partition is used, where the data is stored,
how the results are fetched from the table, and if any index is used or not. You can
use the result from the
explain
SQL command to do an interactive analysis of your
query and then modify it for faster execution as and if needed. You can also use the
results from
explain
to troubleshoot specific issues.
