MySQL optimization key #2: Create the right indexes An index improves query performance by reducing the amount of data in the database that queries must scan.

Sun Microsystems, which acquired Open Source database firm MySQL in January, has apparently found the key to unlocking their plans to make some MySQL features commercial-only: torch-wielding users.