What is a 'Compound Index'?

What is a 'Compound Index'?

Approach: Describe an index on multiple columns.

An index created on two or more columns of a table. The order of columns in the index matters for its effectiveness in filtering queries.

Follow-up: If I have an index on (A, B), can it speed up a query on only B?

Key concepts: column order, query filtering.