what the difference between Create single-column index & Create composite index
from:

what the difference between Create single-column index & Create composite index in mysql. when we create the table and assign index then show two option :
1>Create single-column index,
2>Create composite index.

Poster :
dineshsingh1984