Database Reference
In-Depth Information
Figure 13.1
The output from a join of three tables.
scenes? If we were to run the same script with a log table that contained 1 000 000 rows,
would that script run quickly or could we make it run more efficiently?
Examining Queries
If you have just entered the above query into the MySQL client, click the cursor to the start
of the query and type the word EXPLAIN in front of the query, as shown in Figure 13.2.
EXPLAIN can be run on a table or on a query. Running it on a table, as follows:
EXPLAIN tablename
Figure 13.2
Explaining a query.
Search WWH ::
Custom Search