When making a composite primary key for two or more columns, e.g.
PRIMARY KEY(col1, col2, col3); will the system
INDEX each column individually?
The reason that I am asking this question is that when we use
UNIQUE INDEX (col1, col2, col3), it acts as
INDEX for the first column only, and we need to create additional
INDEXs for other columns. I want to know if that's the case for Composite Primary Key too.