The best PHP and DB Conference of 2006 → php/db|works 2006 Session Schedule → php/db|works 2006 Session Synopsis Index → Explaining EXPLAIN
| Speaker: | Lukas Smith |
|---|---|
| Start time: | Friday @ 10:15 |
| Duration: | 1 hour |
| Talk synopsis: |
Your 3-table JOIN is taking 30 seconds and you do not know why? EXPLAIN is the tool
of choice for getting to the bottom of your performance issues.
In this talk, we will step through optimizing several queries using EXPLAIN. We will
go through all the terminology needed to understand the output from EXPLAIN as well as
how to rewrite SQL, add indexes and other steps to produce optimal queries. Attendees are encouraged to bring along their own laptops to work on the provided examples during the session. |
New Comment
This form allows you to type in a new comment. Keep in mind the following:
- The system accepts input in plain text format. Newlines will be converted to the HTML equivalent, and the system will try to catch most URLs and make them clickable.
- Your e-mail address will never be displayed. We will use it only to notify you when new comments are posted to this page.
- As a rule, we do not delete comments unless they are offensive, racist, spam or otherwise inappropriate.
- Bold fields are required
|
||||||