Single-column index
-
Can a multi-column index on a database be used to query a single column?
Today I was asked a question about database indexes, and I was stumped. So I searched online and organized my thoughts. The question is as follows: If a composite index (multi-column index) is created on columns A and B in a table, will querying column B use this index...?
