Take the 2-minute tour ×

Would a multi-column UNIQUE index qualify for the second condition here?

If so, does that mean that the table will be physically organized based upon that multi-column index?

share|improve this question
add comment

1 Answer

up vote 0 down vote accepted

Confirmed here http://stackoverflow.com/a/1460629/1382306

"Composite primary keys are not necessarily bad, sometimes they can be really helpful because InnoDB clusters them - which means that (disc-bound) range scans over the PK can be satisfied using far fewer IO operations than would be required on a non-clustered index."

Exactly what I was looking for.

share|improve this answer
add comment

Your Answer


