Just wondering...

If I set up a PK to consist of the first two (or three or...) columns
of a table, is each column individually indexed? That is, if I
create a query that has a WHERE condition on, say, the second column,
is that column individually indexed (because it is part of the PK),
or does my query lack indexing assistance?

-- Stan