Database index

Technical Notes

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...?

2019-06-08
3026.2K1

Jake, a native of Hangzhou, studied and worked in the United States for many years. He has experience in technology development, team management, and core business decision-making at Amazon, Shopify, Capital One, Grab, and Oracle, covering advertising technology, payment systems, fintech, and data platforms. He is also seeking new entrepreneurial opportunities in AI applications and cross-border e-commerce. Passionate about creating and practicing from scratch, he welcomes discussion if you share similar interests!

Database index

Can a multi-column index on a database be used to query a single column?